I've currently got this code which searches for the entered keywords in the product title:
mysql_select_db($BLAH);
$query_rs_results = sprintf("SELECT * FROM products WHERE title LIKE '%%%s%%' ORDER BY brand ASC, category", $txtKeywords_rs_results);
$query_limit_rs_results = sprintf("%s LIMIT %d, %d", $query_rs_results, $startRow_rs_results, $maxRows_rs_results);
$rs_results = mysql_query($query_limit_rs_results, $blah) or die(mysql_error());
$row_rs_results = mysql_fetch_assoc($rs_results);
The code works great but I'd like to be able to search multiple fields in the DB like title, text body etc.
Also, how would I do it so that the user doesn't have to enter keywords in the exact order of how they appear in the title?
