SELECT BLAH WHERE BLAH LIKE BLAH not working
| From: | Peter Houchin | Date: | Thu, 15 Feb 2001 03:37:25 +0000 |
| Subject: | SELECT BLAH WHERE BLAH LIKE BLAH not working | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-39801@lists.php.net to get a copy of this message | ||
Hiya, i was wondering if some one could help me with this ... i have a
little form where you can enter a value say company then on submit its ment
to check the db for value or one like it my sql line works fine
(mysql_error() shows nothing and it works from command line) ..
.
.
.
<form name=search method=POST action="<? $PHP_SELF ?>">
<input type="text" name="query">
<input type="submit" name="submit" value="submit">
</form>
<? if ($submit){
echo "<TABLE BORDER=\"0\" CELLPADDING=\"3\" CELLSPACING=\"1\"
BGCOLOR=\"#CCCCCC\" ALIGN=\"CENTER\">\n<tr
BGCOLOR=\"#CCCCCC\">\n<td
bgcolor=\"#006699\"><div align=\"center\"><font
face=\"Helvetica,
sans-serif\" size=\"3\" color=\"#FFFFFF\"><b>Company</b>
</td></tr>";
$result = mysql_query("SELECT company FROM resellers WHERE Company LIKE
'%$query%'");
printf("<tr><td> $company </td></tr>\n");
echo "</table>";
echo mysql_error();
}
?>
Thanks in advance
Peter