mysql_field_type doesnt give all details

[neville]

How do I get the exact feild type using
mysql_field_type ....because right now it doesn't differentiate between int , smallint ,mediumint... or char,varchar,enum

All charachter values are shown as string and all integer values are shown as int...

I need to show the actuall field type ....

Is there any way it can be done ?

[sepodati]

$result = mysql_query("desc table_name");

parse that result for the information you want. Run "desc table_name" at the command line first to see what the output looks like.

---John Holmes...