I am trying to duplicate this action in coldfusion from PHP. I have 2 different list boxes with a date a list of student names. I want to be able to highlight multiple items in each list box and when I run the query to insert the data it will loop through and add a record for each of the combinations selected.
Here is the action in PHP.
foreach ($_POST['Date'] as $d)
foreach ($_POST['stid'] as $stu)
$query = "INSERT INTO ClientServices (DateEntered, Date, SpecialFunction, LengthOfService, Counselor, Client, AA, AAS, CD, FAA, FI, MN, PS, SD, TC, Miscellaneous, DescribeService, user)
mysql_query($query) or die('Error, insert query failed');