Re: [PHP] php selecting problem

On Sun, 2 Nov 2003 00:06:46 +0100, you wrote: >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 rowsany ideas why?

[PHP] php selecting problem

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