Trying to update multiple records - trying to use an array but am in over my head. here's what i have:
update code:
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STR
ING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUE
RY_STRING'
]);
}
if ((isset($_POST["MM_update"
])) && ($_POST["MM_update"] == "spec_order")) {
$updateSQL = sprintf("UPDATE docspec SET order_id=%s WHERE docspec_id=%s",
GetSQLValueString($_POST['
order_id']
, "text"),
GetSQLValueString($_POST['
docspec_id
'], "int"));
mysql_select_db($database_
SCOI2, $SCOI2);
$Result1 = mysql_query($updateSQL, $SCOI2) or die(mysql_error());
$updateGoTo = "specialties4.php";
if (isset($_SERVER['QUERY_STR
ING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
body:
<form action="<?php echo $editFormAction; ?>" method="POST" name="spec_order">
<ul>
<?php do { ?>
<li><strong><em><?php echo $row_rsCurrentSpecs['speci
alty']; ?></em></strong>
<label><br>
Optional Order Number
<input name="order_id[]" type="text" id="order_id[]" size="5" value="<?php echo $row_rsCurrentSpecs['order
_id']; ?>">
<input name="docspec_id[]" type="text" id="docspec_id[]" value="<?php echo $row_rsCurrentSpecs['docsp
ec_id']; ?>">
<br />
<span class="formNote">(If none listed, specialties are ordered alphabetically)</span></la
bel>
<?php } while ($row_rsCurrentSpecs = mysql_fetch_assoc($rsCurre
ntSpecs));
?></ul>
<br />
<input type="submit" name="Submit" value="Update Order Number">
<input type="reset" name="Reset" value="Reset to Original Order Number">
<input type="hidden" name="MM_update" value="spec_order">
</form>
Start Free Trial