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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sptzus at yahoo dot com
New email:
PHP Version: OS:

 

 [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 03:01:27 2024 UTC