Re: MYSQL 4.1 derived tables and PHP
| From: | CPT John W. Holmes | Date: | Fri, 22 Aug 2003 14:11:24 +0000 |
| Subject: | Re: MYSQL 4.1 derived tables and PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30049@lists.php.net to get a copy of this message | ||
From: "Jack van Zanen" <jack@vanzanen.com>
> I have installed MYSQL 4.1 with support for derived tables. If I query
Mysql
> with a query that has a subquery in the from clause it works fine. If I
now
> load this query in PHP I get invalid resource error. If I change the
select
> for another select w/o the subquery it works fine (So my php script must
be
> correct).
>
> Does PHP do syntax checking before sending the query to mysql?
> Any other solution?
> I have tried PHP 4.3.2/4.3.3 & 5.0
What does mysql_error() say?
---John Holmes...