search
| From: | samug | Date: | Fri, 01 Nov 2002 16:39:58 +0000 |
| Subject: | search | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-122433@lists.php.net to get a copy of this message | ||
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.