To select multiple values from checkboxes or a list field and have them appear as individual database entries, use the following code in the Add page: Before Record Added event.
if ($values["fieldname"])
{
$arr = explode(",",$values["fieldname"]);
// This is the name of the multi check box or
// list select field, its value becomes $arr
for ($i=0;$i<count($arr);$i++)
{
$strInsert = "insert into TableName (field) values ('".$arr[$i]."')";
// add more fields from the add page to be inserted into database
db_exec($strInsert);
}
header("Location: MyPage_list.php");
// Exit and Redirect to the list page after updating database
exit();
}
See also:
•JavaScript API:getSelectedRecordKeys()
