Php/mysql error....why?
| From: | Ryan A | Date: | Fri, 24 Oct 2003 16:50:46 +0000 |
| Subject: | Php/mysql error....why? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-167450@lists.php.net to get a copy of this message | ||
Hi,
I am running a very simple query to the database, basically select all the
firms which start with 0-9,
eg.
1stcompany
3isgood
etc
using this:
$qry = "select cust_no,firm from companies where firm LIKE `%0123456789%'";
It gives me this error:
Error: Unknown column '0123456789%'' in 'where clause'
any idea why its ignoring the LIKE statement? the funny part is LIKE is
working for another program..
What am i missing?
Thanks,
-Ryan