#20727 [NEW]: mysql_field_table doesn't work when I use "DATE_FORMAT or NUMBER_FORMAT"....

From: sptzus@yahoo.com Operating system: Linux Slackware PHP version: 4.2.3 PHP Bug Type: MySQL related Bug description: mysql_field_table doesn't work when I use "DATE_FORMAT or NUMBER_FORMAT".... When I use DATE_FORMAT, or NUMBER_FORMAT or any modificator from MySQL, the function mysql_field_table doesn't work. i.e. This WORKS $result = mysql_query("select foo as xpto from patient"); echo mysql_field_table($result, 0); Ok I got "patient" This DOESN'T work $result = mysql_query("select DATE_FORMAT(foo, '%d/%m/%Y) as foo from patient"); echo mysql_field_table($result, 0); I got nothing..... Well that's all. See ya! Thanks! -- Edit bug report at http://bugs.php.net/?id=20727&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=20727&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=20727&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=20727&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=20727&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=20727&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=20727&r=support Expected behavior: http://bugs.php.net/fix.php?id=20727&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=20727&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=20727&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=20727&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20727&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=20727&r=dst IIS Stability: http://bugs.php.net/fix.php?id=20727&r=isapi