extension of mysql?

[djf]

I would like to gennerate a dynamic form based on the columns in a mysql table. But I do not want to display the field names, but a more complete description of the field.

Is it possible to add a column to the "schema definition" to include another attribute?

le. in addition to field, type, null, key, default, and extra; I would like an additional field to contain the "field description".

Not to be greedy, I would like the value to be displayed with a sql show table.

Anyone have any thoughts, ideas?

[stolzyboy]

this may or may not lead you in the right direction

http://www.php.net/manual/en/function.mysql-field-type.php

[djf]

I found no help at the referenced site. I am trying to add info that is presently not in the db definition.

Stated another way.....Where(how) does mysql store the
schema info for each table, i.e. the data displayed with the show table comand?

If it were stored in a user accesable table, I could create another table to use with a join on "Field".