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

On Jan 7, 12:39 pm, paul...@excite.com wrote:
> On Jan 7, 12:33 pm, "Paul Lautman" <paul.laut...@btinternet.com>
> wrote:
>
>
>
> > paul...@excite.com wrote:
> > > 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
>
> > I'm amazed!
> > Looking at your code I would not expect searching on "alpha" to bring back
> > "the alpha dog was there", since this does not begin with the word "alpha".
>
> Hmm, you are right, I didnt notice that, that was just an example,
> not an actual query......hmm, yea if it does not begin with whatever I
> search for I do not get a result?...

I think I fixed this by going from this:
$sql = "SELECT * FROM EDITORIAL WHERE editorialcomments LIKE '$Search
%' ";

to this:
$sql = "SELECT * FROM EDITORIAL WHERE editorialcomments LIKE '%$Search
%' ";

And I think this fixed my initial problem, question

[Back to original message]