forms & mysql

[hhoeksma]

Hi,

I have tried to find an answer to myt question.. but since I do not exactly know if something like this exists or is possible I don't know what to look for!

This is what I would like to know:

Is it possible to 'automatically' generate formfields out of a database using MySql?
I know I can get the content of an array...
But what I mean is: I have 10 different tables in my dbase. I want to have an update, insert, delete form for all these ten tables, but without making ten different forms! Telling to generate a form...

(I hope I am clear in writing down what I want!)

If somebody knows if this is possible and how it works... that would save a lot of time 🙂

[autocolismo]

you could send to the page what table to modify like : page.php?table=table1

then get the var and select from it

$table = $_GET['table'];

"SELECT * FROM $table"

whope you understand me

[hhoeksma]

yeah i get what you mean... but have been searching more and find out that there are some powerfull mysql functions to get tablenames, fields etc.... And that is exactly I was looking for!

Thanx a lot!