Search Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Prezgeek
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 10:55 pm

Search Database

Post by Prezgeek »

Hello Everyone,

I have been wanting to develop an application which would do a small time search from an existing DB, which I already have. I have bene thinking about some search logic but I don't know how to work with a "WHAT", "WHERE" and "WHEN" search. Can anyone help me with this???

Thanks in advance !!!

Regards-
Me.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I'm unfamiliar with the terms you're using. Please explain.
Prezgeek
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 10:55 pm

Search ....

Post by Prezgeek »

:D Thanks for the reply... I want to develop a web based application in PHP5 and MySQL5. I want to impliment the search logic. The website will allow the user to search for specific info with " What"..."Where"...and "When" options. for example I wanna know what is the event in Miami on march 22nd. and then submit it should return me some values. I want to know how to impliment the logic???

Me
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

so, basically, sentence keyword parsing? (like ask.com's search?)
Prezgeek
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 10:55 pm

uhmm

Post by Prezgeek »

Not to that extent but yes....I have a DB and I wanna run search on the DB which I already have pulling data out of different tables and fields.

Me
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

sounds like something for a basic FULL TEXT search then.

http://dev.mysql.com/doc/refman/5.0/en/ ... earch.html
Prezgeek
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 10:55 pm

Post by Prezgeek »

Yeah more or less but I am looking for someone to tell me the logic behind the search option...
Post Reply