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

Hi THX I added mysql_error() to get the error message. I got the message that the user did not have rights on table /tmp/d....bla.bla I figured that I must give some more global read rights to this user (not just DB read rights). After that it worked. THX Jack -----Original Message----- From: CPT John W. Holmes [mailto:holmes072000@charter.net] Sent: Friday, August 22, 2003 4:11 PM To: Jack van Zanen Prive; php-db@lists.php.net Subject: Re: [PHP-DB] MYSQL 4.1 derived tables and PHP 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...