Jump to content


Photo

using the LIKE command


  • Please log in to reply
1 reply to this topic

#1 ferellie

ferellie
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 04 March 2006 - 05:01 PM

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

#2 Hooker

Hooker
  • Members
  • PipPipPip
  • Advanced Member
  • 193 posts
  • LocationWales, UK

Posted 04 March 2006 - 05:28 PM

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]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users