#20727 [Opn->]: mysql_field_table doesn't work when I use "DATE_FORMAT or NUMBER_FORMAT"....
| From: | georg@php.net | Date: | Fri, 29 Nov 2002 22:32:05 +0000 |
| Subject: | #20727 [Opn->]: mysql_field_table doesn't work when I use "DATE_FORMAT or NUMBER_FORMAT".... | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-26207@lists.php.net to get a copy of this message | ||
ID: 20727
Updated by: georg@php.net
Reported By: sptzus@yahoo.com
-Status: Open
+Status: Won\'t fix
Bug Type: MySQL related
Operating System: Linux Slackware
PHP Version: 4.2.3
New Comment:
This is a known bug in the libmysql, which was already reported to
MySQL AB.
Previous Comments:
------------------------------------------------------------------------
[2002-11-29 11:16:59] sptzus@yahoo.com
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 this bug report at http://bugs.php.net/?id=20727&edit=1