mysql help

[el_quijote]

Is ther php function that returns the column names of a mysql table ?...

thanks ...

Quijote

[laserlight]

Consider [man]mysql_field_name/man

You could also try a DESCRIBE TABLE query, methinks,

[el_quijote]

Thank you laserlight. I found very useful your suggestion. Now a litte bit more help. I used to develop applications in access. When you define a table you could set "field comments" that can be used on execution time. I haven't found a similar functionality in MYSQL. Is there somthing alike ?.

Quijote

[tsinka]

Hi,

you can specify a comment for each column with

COMMENT 'a string'

http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

But it is ignored in MySQL versions < 4.1.x

Thomas

[el_quijote]

Hi tsinka! thanks for your promptly response.

Is that comment available from php scripts? I'm planning to use those comments as labels for the insert form of the table ..

Thanks ...

quijote