[PHP-DB] MYSQL 4.1 derived tables and PHP

2003-08-22 Thread Jack van Zanen
Hi List, 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

Re: [PHP-DB] MYSQL 4.1 derived tables and PHP

2003-08-22 Thread CPT John W. Holmes
From: Jack van Zanen [EMAIL PROTECTED] 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

RE: [PHP-DB] MYSQL 4.1 derived tables and PHP

2003-08-22 Thread Jacob A. van Zanen
- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 4:11 PM To: Jack van Zanen Prive; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MYSQL 4.1 derived tables and PHP From: Jack van Zanen [EMAIL PROTECTED] I have installed MYSQL 4.1 with support for derived tables. If I