From: burg1 at gmx dot net Operating system: PHP version: 5.2.0 PHP Bug Type: Feature/Change Request Bug description: mysql_query: return the actual MySQL output, not just TRUE
Description: ------------ Currently, the mysql_query() function returns a resource only on some commands (SELECT, SHOW, DESCRIBE or EXPLAIN). On any other command, it just returns TRUE. My suggestion: Let the function return the actual MySQL output on those "other commands" (I'm talking about commands like ANALYZE TABLE that do generate an output). Could be given as an associative array, or if that's not possible, just as a string. This way, mysql_query would return: *) a resource on SELECT, SHOW, DESCRIBE or EXPLAIN *) an array/string on commands that give an output (OPTIMIZE TABLE, etc.) *) TRUE on commands that don't give an output (DELETE, etc.) *) FALSE on error -- Edit bug report at http://bugs.php.net/?id=40377&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40377&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40377&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40377&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=40377&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=40377&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=40377&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=40377&r=needscript Try newer version: http://bugs.php.net/fix.php?id=40377&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=40377&r=support Expected behavior: http://bugs.php.net/fix.php?id=40377&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=40377&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=40377&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=40377&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40377&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=40377&r=dst IIS Stability: http://bugs.php.net/fix.php?id=40377&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=40377&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=40377&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=40377&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=40377&r=mysqlcfg