[using the LIKE command]

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

[php mysql]

[!--quoteo(post=351329:date=Mar 3 2006, 02:06 PM:name=craygo)--][div class=\'quotetop\']QUOTE(craygo @ Mar 3 2006, 02:06 PM) [snapback]351329[/snapback][/div][div class=\'quotemain\'][!--quotec--]
since web is a string you have to encase it in quotes
[code]$result = mysql_query("select * from $table WHERE categories LIKE '%web%' order by id desc limit $rows", $link)
or die ("Could not read data because ".mysql_error());[/code]

Ray
[/quote]


[!--quoteo(post=351329:date=Mar 3 2006, 02:06 PM:name=craygo)--][div class=\'quotetop\']QUOTE(craygo @ Mar 3 2006, 02:06 PM) [snapback]351329[/snapback][/div][div class=\'quotemain\'][!--quotec--]
since web is a string you have to encase it in quotes
[code]$result = mysql_query("select * from $table WHERE categories LIKE '%web%' order by id desc limit $rows", $link)
or die ("Could not read data because ".mysql_error());[/code]

Ray
[/quote]


thank you but how do I get the text from the input box to replace the text 'web' in my code?

Thanks

[php mysql]

I am using table with several fields which I display in a div no problem. I need to display all fields on a seperate page where the categories field contains the string web as an example. This is my code..

<?php

include "config.php";

// connect to the mysql server
$link = mysql_connect($server, $db_user, $db_pass)
or die ("Could not connect to mysql because ".mysql_error());

// select the database
mysql_select_db($database)
or die ("Could not select database because ".mysql_error());

// read data from database
$result = mysql_query("select * from $table WHERE categories LIKE %web% order by id desc limit $rows", $link)
or die ("Could not read data because ".mysql_error());
?>

AND TO DISPLAY IN A DIV

<?php
// print the data in a div
if (mysql_num_rows($result)) {
while ($qry = mysql_fetch_array($result)) {
?>

<div id="business">

<?php
print "$qry[business]<br>";
?>
</div>

<div id="businessdescription">
Business description:</div>
<?php
print "$qry[description]<br>";
?>

<div id="contactname">
Contact person:</div>

<?php
print "$qry[name]<br>";
?>

<div id="location">
Location:</div>

<?php
print "$qry[town]";
?>
&nbsp;
<?php
print "$qry[postcode]<br>";
?>

<div id="telephone">
Telephone:</div>

<?php
print "$qry[phone]<br>";
?>

<div id="website">
<a href="

<?php
print "$qry[website]";
?>

">Visit Company Website</a></div>

<div id="endseperator"></div>

<?php
}
}
mysql_close();
?>

MY CONFIG.PHP CONTENTS IS

<?php
$server = "localhost"; // server to connect to.
$database = "pages"; // the name of the database.
$db_user = "pages"; // mysql username to access the database with.
$db_pass = "pass"; // mysql password to access the database with.
$table = "denb"; // database table
$rows = 500; // the number of table rows to display
?>

I would really appreciate any help,

Thank you.