php selecting problem
| From: | Ryan A | Date: | Sat, 01 Nov 2003 23:06:46 +0000 |
| Subject: | php selecting problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-168305@lists.php.net to get a copy of this message | ||
Hi,
Is this PHP's or Mysql fault or my own ( most likely)?
I'm doing a simple query to the DB and want any companies which start with a
number as the first "letter" to come up...
eg:
1company
23blah company
007bonds company
7lucky seven
etc
This is my query:
if($bok==1)
{$query = "select compno,thCompany from main_company where thCompany LIKE
'%0123456789%'";}
I have looked in the DB and i see quite a few companies have a number in the
beginning, but still this returns me no rows....any ideas why?
Thanks in advance,
-Ryan