multiple list values to one field
Posted: Fri Apr 27, 2007 3:46 pm
Is there a way to save multiple list selections from a form field into 1 field in MySQL? Right now it's only saving the first entry from my list. Thanks!
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<SELECT MULTIPLE NAME='choice[]'>
...
</SELECT>
Code: Select all
foreach($choice as $value) {
...
}Code: Select all
<select name='activities[]' size="10" multiple="multiple" id="activities">
....
</select>Code: Select all
$date = date("Y-m-d G:i:s");
$sql = "INSERT INTO `signup2` VALUES (
\"\",
\"$_POST[firstname]\",
\"$_POST[lastname]\",
\"$_POST[maidenname]\",
\"$_POST[gradyear]\",
\"$_POST[email]\",
\"$_POST[city]\",
\"$_POST[state]\",
\"$_POST[country]\",
\"$_POST[url]\",
\"$_POST[email_private]\",
\"$_POST[aol]\",
\"$_POST[myspace]\",
\"$_POST[activities]\",
\"$_POST[update]\",
\"$_POST[username]\",
\"$_POST[password]\",
\"$date\",
\"$date\"
)";