Posted by paul814 on 01/07/08 17:17

Hello everyone,
Right now I have a simple PHP page setup that takes whatever was
entered into txtsearch on the previous page, it searches my DB by that
word and brings back the whole record based on the word.

So if I enter: ALPHA
it will bring back this record: the alpha dog was there

HOWEVER if I enter: ALPHA DOG or alpha dog
(so if I enter more than one word) it does not find any records. How
can I fix this so that if I enter ALPHA DOG it will find the record:
the alpha dog was there

Here is my code:
==============
<?php
$host="localhost";
$user="root";
$pass="";
$db="productiondb";
$con = mysql_connect($host, $user, $pass);

$Search = $_POST["txtsearch"];

if (!$con)
{
die('Unable to connect: ' . mysql_error());
}
mysql_select_db($db, $con) or die('Unable to connect: ' .
mysql_error());


$sql = "SELECT * FROM IT WHERE itcomments LIKE '$Search%' ";
$rs = mysql_query($sql,$con);

while($row=mysql_fetch_object($rs)){

print "<div class=\"message\">";
print " <h3 class=\"red\">" . $row->itdate . "</h3>";
print " <h5 class=\"red\">" . $row->itname . "</h5>";
print " <h4 class=\"red\">" . $row->itcomments ."</h4>";
print "############### END OF RECORD ###############";
print "</div>";
}
?>

thanks for any help

• Next in forum: Re: if an multiple statements
• Prev in forum: Re: Usability Job Opportunities
• Thread view: Search DB by more than one word

[Reply to this message]