proper placement of implode code for adding multiple options
Hi - Here is the code block that governs the drop down options list and inserting them into the database table. Question: where within this block does the IMPLODE stuff go?
--------------
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "update_practice")) {
$updateSQL = sprintf("UPDATE tblPractice1 SET memberID=%s, DIMENS=%s, INTERESTS=%s, languages=%s, ages_served=%s, treatment_techniques=%s, geo_location=%s WHERE practiceID=%s",
GetSQLValueString($_POST['memberID'], "int"),
GetSQLValueString($_POST['DIMENS'], "text"),
GetSQLValueString($_POST['INTERESTS'], "text"),
GetSQLValueString($_POST['languages'], "text"),
GetSQLValueString($_POST['ages_served'], "text"),
GetSQLValueString($_POST['treatment_techniques'], "text"),
GetSQLValueString($_POST['geo_location'], "text"),
GetSQLValueString($_POST['memberID'], "int"));
mysql_select_db($database_mem1, $mem1);
$Result1 = mysql_query($updateSQL, $mem1) or die(mysql_error());
$updateGoTo = "confirmation.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
--------------
This is using straight DW update record behavior. Next post will include Data Assist Update Single Record Behavior. Neither DW nor WA-data assist can take the insert multiple options from drop down menus.
thanks,
elizabeth