ID: 25210 Updated by: [EMAIL PROTECTED] Reported By: jack at vanzanen dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: United Linux 1.0 PHP Version: 4.3.2 New Comment:
Use the MySQLi extension which is available in PHP5, dunno about PHP4. Previous Comments: ------------------------------------------------------------------------ [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
