Building forms using mysql column info

[msore]

I am trying to build a class to create forms for each of the tables in my database.

How can I use the mysql information to:
get column names
get column types
get column type size (varchar(30))!

Are there built in mysql_functions to retrieve this info?

Thanks!

[Anon]

such a software does already exist :

http://phpwizard.net/projects/phpMyAdmin/

cu
Santos

[msore]

phpmyadmin is too much for my needs.
I only need a simple class structure for an application Im building.

[Anon]

USE:
mysql_field_name -- Get the name of the specified field in a result
mysql_field_type -- Get the type of the specified field in a result
mysql_field_len -- Returns the length of the specified field

For details access: http://www.php.net/manual/en/ref.mysql.php

Did you understand?

Leandro.