Dynamically changing the table to insert the data to ...

using a drop down menu

[le_gber]

Hi all,

I wanted to dynamically change the table in which I am inserting data according to the value selected in the drop down menu of the submitted form.

Is this possible? How to do it?

Thanks or your help

Leo

[coopster]

Are you inserting or updating data in your table? If you want to INSERT data in your table with a value selected by the user on an HTML form, you simply use the POSTed data:

$sql = "INSERT INTO table VALUES('" . $_POST['select_name_from_HTML_form'] ."')"; 

[jatar_k]

or

$sql = "INSERT INTO " . $_POST['tablename'] . " VALUES('" . $predefined_cols ."')";

[le_gber]

Cheers guys!

Leo