In essence, what this code does is it creates a table with a dropdown menu of 3 houses, each one with a different value.
Now i am using this php code to store the values in a mysql database.
<?php mysql_connect("localhost", "user", "pass") or die(mysql_error()); mysql_select_db("data1") or die(mysql_error());
$houses = $_POST["houses"];
mysql_query("INSERT INTO test(houses) values('$houses') ") or die(mysql_error()); ;?>
Now what i would like to do is to store both the value and the name of the selection made by the user. For example, if the user selects the first option, the data stored in the database is only 100000. How can i modify my php or the html code from the form to be able to insert the 100000 and also House 1 into the database. I need both values to be passed on to my database.