query / field name problem

[Anon]

Hi there,

Does somebody knows how to get the REAL table name when i do a query with AS in it..

like this:
"select user as username from member"

when I use the function mysql_fetch_field
and then $object->name, the name of the field is username...
But i want the name to be user...or whatever the real name of the field is??

can you help me please??

Thanx

[Anon]

why don't you just do "select user from member" ???

[[deleted]]

You can't.

When you use the 'as' statement, you specifically tell sql NOT to use the real name.