dynamic form based on database data types ??

[stuartc1]

Hi PHP Buddies,

OK, here is what I want to do:
I want to dynamically draw a form with element that relate to field datatypes in a database. Say I have a database with a table called 'mytable' and the following fields - myID(tinyint) - MyBigField(varchar 250) - MyWeeField(varchar 10). I want to create a form were myID = input type=text maxsize=3 - MyBidFields = textarea - MyWeeField = input type=text maxsize=10.

Any ideas of the best way to do this, or anyone seen a pre-build class/script that does this ??

[ednark]

UTSL: here is what you do...

1) goto: http://phpmyadmin.sourceforge.net

2) download it

3) search the souce till you see how it figures these things out. If you haven't used it, it is a web frontend to administrating a mysql database, When you enter in a row for a table, it somehow knows what type of form fields to use, their limits, and makes pulldowns from data

4) use whatever technique they are using for your own devious purposed

5) become rich