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

2003-08-22 Thread Jacob A. van Zanen 
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/dbla.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:[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 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...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 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...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php