#25210 [Bgs->Csd]: Invalid resource when using query with derived tables

ID: 25210 User updated by: jack at vanzanen dot com Reported By: jack at vanzanen dot com -Status: Bogus +Status: Closed Bug Type: MySQL related Operating System: United Linux 1.0 PHP Version: 4.3.2 New Comment: My err: I set mysql_error to find out that it was a rights issue. I had to grant the user more rights globally on mysql instead of full rights on it's own database. Apparantly for derived tables a temp table is being created and the user did not have read rights on this one since it was not in his own database. Previous Comments: ------------------------------------------------------------------------ [2003-08-22 12:04:09] georg@php.net Magnus, thats not a problem of ext/mysql or ext/mysqli. mysql_query returns false, if an error occured (as described in the manua!). Check your error with mysql_error or errno. ------------------------------------------------------------------------ [2003-08-22 11:05:32] magnus@php.net Use the MySQLi extension which is available in PHP5, dunno about PHP4. ------------------------------------------------------------------------ [2003-08-22 09:29:17] jack at vanzanen dot com Description: ------------ 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). I have tried PHP 4.3.2/4.3.3 & 5.0 TIA Jack Reproduce code: --------------- http://www.vanzanen.com/source.txt Expected result: ---------------- I expect the query to produce data that is shown on the screen as a html table Actual result: -------------- $result is not a valid resource ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=25210&edit=1