jbrill Posted June 29, 2007 Share Posted June 29, 2007 Hey, Im looking to create a very simple search for the website I'm working on. I need it to search the table "products" in the following fields: "prod_number" "name" "keywords" I have been able to write a simple little script that processes the the form and sends it to "search.php" where it looks for the correct matches. The problem with the script is that it only finds exact matches ( this would work for the part number as there is only one per product) but if the user is searching for a keyword they will obviously not know the exact name of the product, thus it will not show. can anyone help me out? Thanks in advance! Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/ Share on other sites More sharing options...
jbrill Posted June 29, 2007 Author Share Posted June 29, 2007 no one can help? Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/#findComment-286160 Share on other sites More sharing options...
per1os Posted June 29, 2007 Share Posted June 29, 2007 Use the LIKE operator with the % wildcard. Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/#findComment-286164 Share on other sites More sharing options...
jbrill Posted June 29, 2007 Author Share Posted June 29, 2007 ??? huuuuuuuuh? haha could you please explain a bit more? Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/#findComment-286165 Share on other sites More sharing options...
melvincr Posted June 29, 2007 Share Posted June 29, 2007 this is more a mysql question.. $query = "SELECT * FROM products WHERE name LIKE '%".$_REQUEST['keyword']."%'"; the % is a wildchar for any character.. Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/#findComment-286166 Share on other sites More sharing options...
jbrill Posted June 29, 2007 Author Share Posted June 29, 2007 PERFECT! thanks so much! Link to comment https://forums.phpfreaks.com/topic/57774-creating-a-simple-boolean-search-help/#findComment-286177 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.