Multiple Searches

[Anon]

I've set up a search for MySQL and everything is working great. i can make them lie up like a like 3 to a row, and seperate to 15 per page. I can make the Prev 12345.. Next links and even count my finds and put a nice little 777 Search results for Mountains thingy on the top of my page. All of this is well but im finding my nice little search englien useless because i can not search for more than one thing at a time. I tried a few different ways but those i tried caused errors. i need some help before i beat my pretty little search engiene into the Recycle Bin ;-) I do great if i search for mountains but when i search for mountains sunset i get only the mountain resonse. If i use or i get a error when only one word is typed and i would ahve to add a million. SO HELP! ;-)

[[deleted]]

Oh, don't throw your pretty little search engine into the evil recycle bin! 🙂

Can you post a piece of the code where you create the SQL-query
and explain the problem in a bit more detail.

[Anon]

OK in more detail I can search for one word but I dont know how i make a loop that will check and see if the next array is set after the explode, then if it is, add a SQL "or" command. to search for both arrays so they will bot be stored in the same varable. Here is the code i use to get the results from the database.

$result=mysql_query("select * ".
"from tags where description LIKE '%{$searchstring}%' ".
"limit $page, $limit");

while ($data=mysql_fetch_array($result) ) {
echo("<td><a href=focus.php?focus=" . $data["ID"] . "><img width=111 height=58 border=0 src=./images/tags/" . $data["spicurl"] . "></a></td>");

Please help me get this goin man. If i do ill have all the bugs worked out and I can move on and try to beat some deadlines. Thanks andn "Die Recyle Bin DIE!!!"

[[deleted]]

// Get the search keywords
$sSearch = "this that foo bar";

// make an array out of it
$aSearchWords = explode(' ',$sSearch);

// build a load of 'LIKE' clauses
$sSearchString='';
for ($t=0;$t<count($aSearchWords);$t++)
{
$sSearchString.=' description LIKE \'%'.$aSearchWords[$t].'%\'';
};

// Make a complete query.
$sQuery = "SELECT * FROM table WHERE ".$sSearchString;

// execute and process