ferellie Posted March 4, 2006 Share Posted March 4, 2006 I am using the following code to search for information in my database using keywords which are inputted into a search box. foreach($_POST as $key => $val) { // This loops through the form variables$$key = $val; // Assigns variables with the same names as the input names} // i.e. the text box inputSearch would have a variable name of $inputSearch// read data from database$result = mysql_query("select * from $table WHERE keywords LIKE '%$inputSearch%' order by id desc limit $rows", $link)or die ("Could not read data because ".mysql_error());Problem is, the query results are not quite what I had in mind! If the field contained the words 'one two three' and the user searched for 'three two' the query would return nothing. Is there a way of modifying the search to accomplish this? I want my search to find any matching words.Thanks again,Peter Quote Link to comment https://forums.phpfreaks.com/topic/4092-using-the-like-command/ Share on other sites More sharing options...
Hooker Posted March 4, 2006 Share Posted March 4, 2006 have you taken a look at this tutorial:[a href=\"http://www.phpfreaks.com/tutorials/129/0.php\" target=\"_blank\"]http://www.phpfreaks.com/tutorials/129/0.php[/a] Quote Link to comment https://forums.phpfreaks.com/topic/4092-using-the-like-command/#findComment-14202 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.