I've made search engine on my webshop that works fine, exept that it's only outputting the rows that have a field matching the search word perfect. Here:
Code: Select all
$result = mysql_query( "SELECT * FROM products WHERE category='".$_POSTї'word']."' OR prodnr='".$_POSTї'word']."' OR product='".$_POSTї'word']."'" );Now there is like this, if someone search for "socks" and the there is a field containing "super socks" this does not give a hit. You have to search for the exact word. In this case "super socks".