Re: search

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