display colum names from sql

[Salvador_nl]

i have been messing with db2_ commands, but can not get it to display my sql table colum names?!

is there an alternate, or should it work always?

[eelixduppy]

Take a look at mysql_list_fields [us3.php.net]

[Salvador_nl]

thanks a LoT!

i was expecting there would be another command, just could not get the right search phrase ;)

THANKS!

[eelixduppy]

You're welcome. You can find a myriad of information at [php.net...]

[coopster]

Just so you are aware though, the

mysql_list_fields

function is deprecated. The PHP manual recommends issuing a mysql_query() [php.net] statement instead. Details on the mysql_list_fields [php.net] function page. Also, the syntax of the SQL statement will be different for the IBM DB2 database if that is indeed the database you are using.