php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #20727 mysql_field_table doesn't work when I use "DATE_FORMAT or NUMBER_FORMAT"....
Submitted: 2002-11-29 11:16 UTC Modified: 2002-11-29 17:01 UTC
From: sptzus at yahoo dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.3 OS: Linux Slackware
Private report: No CVE-ID: None
 [2002-11-29 11:16 UTC] sptzus at yahoo dot 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!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-11-29 16:32 UTC] georg@php.net
This is a known bug in the libmysql, which was already reported to MySQL AB.
 [2002-11-29 17:01 UTC] derick@php.net
Not a bug in PHP -> bogus
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Sep 29 01:01:26 2024 UTC