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());