how to insert data into different tables selected from combobox

[mbemua]

i have try this code

<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="bankofquestions"; // Database name
 
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
 
if(isset($_POST['select_3']) && $_POST['select_'] == 'chem_v_qn1'){
 
$question = $_POST['question'];
 
$query="Insert into _v_qn1 (question) values ('$question')"; 
 
    mysql_query($query) or die ('error updating database');
 
    echo "database updated with '$question'";
 
}
?>

[Rabbit]

Just change it from a static table name to the value in your combobox.

But you should be aware that you are wide open for SQL injection attacks. And also, since you are inserting similar data into multiple tables, your database structure is most likely not normalized. There's really not a need to do this.

[mbemua]

I have want to make a combo box in dreamweaver using php and html.After selecting any table from the combo box the user writes his question in text box related to that particular table.In mysql i have made separate tables of every questions mentioned in combo box.Now i want that whenever user press the submit button after selecting the table from combo box the the question he writes in the textbox is inserted to that relevent table for example if table one is selected then the questions in text box should be saved in table one in database.I do not have the code.Any kind of help will be appreciated.

[Rabbit]

What do you mean you don't have any code? You posted your code in the first post. You just need to implement my suggestion in post 2.

Also, you should be aware that this is not a code writing service. We will help you troubleshoot your code but we are not here to give you code.

And finally, you should not have separate tables for every question. That breaks the rules of normalization and makes it more difficult for you to write queries. As has already been witnessed. So I would suggest that you redesign your tables.