Re: php'ed mysql query
| From: | Ignacio Vazquez-Abrams | Date: | Tue, 16 Jan 2001 19:39:15 +0000 |
| Subject: | Re: php'ed mysql query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-34890@lists.php.net to get a copy of this message | ||
On Tue, 16 Jan 2001, Christopher Allen wrote:
>
> Hello,
> Can anyone tell me why this query errors out? It works from the mysql
> client command line just fine....
>
>
> $query1 = "select * from zip_base where '$zip1' >= zip &&
> '$zip1' <= CONCAT
> (SUBSTRING(zip , '1' , LENGTH (zip) - LENGTH (range) ), range)";
>
>
>
>
> Christopher C. M. Allen
>
Does the MySQL user ID you're connecting as have select permissions on the
database?
--
Ignacio Vazquez-Abrams <ignacio@openservices.net>