Mysql Field List

[jenniferG]

We would like to be able to  get the column list of a mysql Table from PHP code.  I know from the mysql prompt we can get it, but we want to  generate PHP  code

that  will retun an array  of columns  If  there is a column descriptor containing

name, size, etc, that would be great. Something that I could loop thropugh an array in

PHP4 and  get  the names of all the columns in the table as well as perhaps

other column  parameters as well. I believe that can be done in CGI, but want to use

PHP4.

 

Thanks,

Jennifer

[Wildbug]

You can run a DESCRIBE table as you would from a prompt and parse the output.