Re: [PHP] search

[John Nichel]

And you may want to try....

$query = "select `id`, `link`, `heading`, `desc` from `links` where `heading` like '%" . $entry . "%' or `desc` like '%" . $entry% . "' or `keyword` like '" . %$entry% . "'";
if ( ! $inquiry = @mysql_query ( $query, $connection ) )

Robert Cummings wrote:

Echo your query and ensure that $entry has data in it, otherwise
matching '%%' will match everything as you are getting.

Cheers,
Rob.

samug wrote:

There's no php.sql, so I'll put it here.

I'm trying to do a search from mysql database like this:

if (!$inquiry = mysql_query("select id,link,heading,desc from links where
heading like '%$entry%' or desc like '%$entry%'
or keyword like '%$entry%'",$connection)){
   print "<LI>Search was unsuccesful!";
}
else{
   while ($link = mysql_fetch_row($inquiry)){
       print "<LI><A HREF=\"" . $link[1];
       print "\">" . $link[2];
       print "</A> <I>" . $link[3] . "</I>" ;
   }

}

But everytime I get all the possible entries, even though I'm sure it
doesn't match.

Thanks for your answers.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php