posting to tables depending on drop menu

[Anon]

O.k I was wondering if someone could give me the outline of some form code. I have managed to post entries using a form. I have 2 tables in my database.

Great Britain
Scotland

the user enters info into the form, I want them to be able to decide where there data gets posted via a drop down menu. So if they choose scotland from the drop down the data gets saved to the scotland table. If they choose Great Britain from the drop down the data gets saved to Great Britain table. Is it possible to do this from a drop down menu, instead of having to loads of forms. I would appreciate a code snippet.

[Anon]

<?php
switch($dropdown_value) {
case ("Great Britain"):
$table_name = "greatbritain";
break;
case ("Scotland"):
$table_name = "scotland";
break;
}

$query = "INSERT INTO " . $table_name . " VALUES ";
$query .= "(" . $val1 . "," . $val2 . ")";

// now run your query
?>

If your tables are all setup the same just turn your table_name into a variable that is either set by the dropdown box, or can be set by that value. I did the latter up above just to show it, but it'd be cleaner just using the dropdown value as the table name.

[Anon]

Thank you very much for your help