[RESOLVED] mysql_fetch_field Question

[dreams4000]

Hey all,

I have a pretty standard mysql query that has a few items like SELECT AVG(col_name), MAX(col_name) etc..

mysql_fetch_field() seems to nab avg(col_name) as the field name rather than col_name and it doesn't pull the table name either when using its "table and name" options. It works fine and dandy on the sql query without the avg, max, count etc. I have also tried doing a "avg(col_name) as col_name" but the table name still does not get pulled at that point, only the field name.

Any ideas? Thanks.

[bradgrafelman]

I tested this out on my own SQL server, and you're right - a normal column will return table information, but using a MySQL function will not. I guess that's because when you're using a function, you're not actually talking about data from the table - you're actually SELECT'ing a computed value based on the outcome of a function.

So really, there isn't a table associated with the data from an AVG/MAX/etc. function - it's just data that has been calculated.

[dreams4000]

Alrighty. Thanks for the response on this. Too bad it wont grab that info:\