User Rated at:
Rate This:
Select a rating... 5 .. Best 4 3 .. Average 2 1 .. Worst

this little script will search a database for the searched words. the advantage is that if the user enters more than one work seperated by spaces, it will break them apart at the space and search for each individual one.

<!---Head--->
none

<!---Body--->

<?php

$search = "your text here";
$search_words = explode(' ', $search); 

$result = mysql_query ("SELECT * FROM table WHERE $category LIKE '%$search_words[0]%' AND $category  LIKE '%$search_words[1]%' AND $category  LIKE '%$search_words[2]%'"); 
?>