Re: Creating mySql search feature.....

Hello, What you need is : 1- parse your query and make it boolean "apple orange" become "apple and orange" and so on 2- then you can generate a MySQL query based on that like this way ----------- SELECT id, field1 match (field1) against (' apple orange ') as relevance FROM hospitality WHERE match (field1) against ('apple')>0 AND match (field1) against ('orange')>0 HAVING relevance>0 ORDER BY relevance DESC ----------- field1 will be your field(s) you're searching in. Hope this will help Hatem "Cookra" <cookra@btinternet.com> a écrit dans le message de news: 20021124105118.81779.qmail@pb1.pair.com... > Hi all, > Need a little help here been at this for a while now... > > I have a database holding a table which in turn holds a collection of fields > I need to search. > > Ive set up search form that sends the variable $S_For and $S_From, these > variables represent the following: > > $S_For = the search keyword itself > $S_From = the column which I need to search > > Ive created this and it works fine for single words, the problem as you may > of guessed is when I enter a string of words ie: > > apple - works fine > > orange - works fine > > apple orange - doesnt > > Any help would be ideal!!!! > > ----------------- > > Databse = clientacc > Table = hospitality > > ----------------- > > Everything else works on my site apart from this search > feature.............. please help! > > > Regards > > R > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php