How to send option values to diffrent db tables

[beezgoodtimez]

<select class="formFields">
<option value="test">test</option>
<option value="test2">test2</option>
<option value="test3">test3</option>
<option value="test4">test4</option>
</select>

( I want to send each option value to a different table in db)
so i can have each categories for each table

[Rabbit]

I have no idea what your goal is. Why would they be in their own table?

[Bharat383]

first save the value of option in temp_variable then write a query ( if you have make first each table for each category)

$table_name = $_POST['category_option'];
query == >
$qry = "insert into ".$table_name." values(1,'product_name',100)";

$query = mysql_query($qry) or die(mysql_error());

try it .....

Bharat Parmar (Bharat383)