Adding <select opttions> more than one value into mysql
Posted: Mon Nov 30, 2009 3:22 am
Hey.
I traying to add more than one value into the database. by using the the option.
Ex. USA country -> into table country. And Dollar currency -> into table currency.
I'm using this mysql connection to insert into tables. :
What is the correct code for inserting Country and Currency, Ehat do I need the change... Plzz help
I traying to add more than one value into the database. by using the the option.
Ex. USA country -> into table country. And Dollar currency -> into table currency.
Code: Select all
<select name="country" id="select8">
<option value="USA,Dollar">USA</option>
<option value="Germany,EURO">Germany</option>
</select>
Code: Select all
mysql_query("INSERT INTO users
(`user_email`,`user_pwd`,`country`,`transacc`,`joined`,`activation_code`,`full_name`,`Website`)
VALUES
('$_POST[email]','$md5pass','$_POST[country]','$_POST[transacc]',now(),'$activ_code','$_POST[full_name]','$_POST[Website]')") or die(mysql_error());