Using the following dynamically generated drop down menu, I capture the values for a variable variable:
echo "<select class=\"lite_orange\" name=\"${$proj_chk_value_status}[]\" style=\"height:20px; width:48px;\">";
echo "<option selected value=\"$proj_chk_value_status\">";
echo $proj_chk_value_status;
echo "</option>";
echo "<option value=\"no\">no</option>";
echo "<option value=\"yes\">yes</option>";
echo "<option value=\"n/a\">n/a</option>";
echo "</select>";
Once submitted, I want to update a database with the values captured. I am using the code below to update the records, and I think that I need to use either a while or a for statement to cycle through each respective value, but I am unable to think through the proper structure.
Help!
revez
// Create an array for the checklist values
$checklist_values_array = $_POST["proj_chk_value_status"];
$cv_ids = implode(",", $checklist_values_array);
$checklist_update_query = mysql_query("UPDATE NRT_PROJECTS_CHECKLISTS_VALUES SET proj_chk_value_status='$proj_chk_value_status' WHERE proj_chk_ID IN ($cv_ids) AND proj_ref_ID='$proj_ref_ID'");
