Take a look at that:
http://www.mysql.com/doc/S/H/SHOW.html
and
http://www.mysql.com/doc/D/E/DESCRIBE.html
I fear you have to parse necessary information out of a statment like this:
$result = mysql_query("DESCRIBE yourTable");
$tabelDesc = mysql_fetch_array($result);
I didn't spend any time checking it but I think it could work.
Good luck!
PS: if you make progress with that I was also interested in informations
about this kind of stuff - please send a mail :)
Stefan Rusterholz, [EMAIL PROTECTED]
----------------------------------
interaktion gmbh
Stefan Rusterholz
Zürichbergstrasse 17
8032 Zürich
----------------------------------
T. +41 1 253 19 55
F. +41 1 253 19 56
W3 www.interaktion.ch
----------------------------------
----- Original Message -----
From: "Justin French" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 3:02 PM
Subject: [PHP] mysql table information
> hi,
>
> i was wondering if anyone has some sample code / links which could help
> me generate HTML forms dynamically from the fields/types/lengths of
> tables in a mySQL database.
>
> ie, if i had a three column table with first (varchar 50), last (varchar
> 80) & bio (medium text) as the columns, it'd be great if i could use
> this information about the *table* to build a html form.
>
> in otherwords, I could generate an <INPUT> named "first" who's max
> length was 50, annother called "last" with a maxlength of 80, and a
> <TEXTAREA> named "bio" for the medium text, etc etc.
>
>
> sorry i can't describe it any better!!
>
>
> i guess programs like phpMyAdmin achieve this, but i'd rather see a
> small code snippet and LEARN rather than dig through 1000's of lines of
> phpMyAdmin code :)
>
>
> thanks,
>
> justin french
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
