Jump to content


This topic is now archived and is closed to further replies.


using the LIKE command

Recommended Posts

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,


Share this post

Link to post
Share on other sites
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]

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.