Page 1 of 1

Search Database

Posted: Tue Mar 21, 2006 11:18 pm
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.

Posted: Tue Mar 21, 2006 11:20 pm
by feyd
I'm unfamiliar with the terms you're using. Please explain.

Search ....

Posted: Tue Mar 21, 2006 11:24 pm
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

Posted: Tue Mar 21, 2006 11:32 pm
by feyd
so, basically, sentence keyword parsing? (like ask.com's search?)

uhmm

Posted: Tue Mar 21, 2006 11:35 pm
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

Posted: Tue Mar 21, 2006 11:37 pm
by feyd
sounds like something for a basic FULL TEXT search then.

http://dev.mysql.com/doc/refman/5.0/en/ ... earch.html

Posted: Tue Mar 21, 2006 11:50 pm
by Prezgeek
Yeah more or less but I am looking for someone to tell me the logic behind the search option...