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! Quote Link to comment Share on other sites More sharing options...
jbrill Posted June 29, 2007 Author Share Posted June 29, 2007 no one can help? Quote Link to comment Share on other sites More sharing options...
per1os Posted June 29, 2007 Share Posted June 29, 2007 Use the LIKE operator with the % wildcard. Quote Link to comment 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? Quote Link to comment 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.. Quote Link to comment Share on other sites More sharing options...
jbrill Posted June 29, 2007 Author Share Posted June 29, 2007 PERFECT! thanks so much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.