select box List questions

I have a form that has a multiple selct box on it. I want to insert the values of each option selected into the database seperately.

Does this get passed to the next page as a comma delim list (as it does in Cold Fusion, which I am used to)?

What functions should I be learning about? Does anyone have specific code example I can reference?

Thanks for the patience while I learn!

Brant

Hi!
You can name it as an array, for example:

<select name="mySelect[]">
<option value="first">First</option>
<option value="second">Second</option>
<option value="third">Third</option>
<option value="forth">Forth</option>
</select>

In PHP use this:

<?php
$howmany = count($mySelect);
if($howmany > 1) {
for($i = 0; $i < $howmany; $i++) {
$sql = "INSERT INTO table VALUES ('" . $mySelect[$i] . "')";
}
} else {
$sql = "INSERT INTO table VALUES ('" . $mySelect[0] . "')";
}
?>