[PHP] SELECT BLAH WHERE BLAH LIKE BLAH not working

[Peter Houchin]

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