Hello..
If anyone enters more than 1 word in a text-box to search a database, what does the query look like then? (using MySQL)
Right now, i have this:
$SQL_statement_total = "SELECT * FROM table WHERE description LIKE '%$keyword%' AND cat_id='$detectnumber'";
But if anyone enters more than 1 word, the script fails to work, finds nothing, though i tried it, entered 2 words of which i know are in the same record of the database, does not work
Anyone?
thefisherman
