I got the update to work, but I'm getting these warnings/errors at the top of the webpage:
Error, unable to update database:
Unknown column 'person_id' in 'where clause'
It's strange because the database DOES get updated...
--------------------------
----------
----------
----------
----------
--------
<?php
error_reporting(E_ALL);
session_start();
header("Pragma: no-cache");
include("util.php");
securityCheck();
$locationFeedback = " ";
$feedback = " ";
$isPostback = FALSE;
if (array_key_exists("Submit"
, $_REQUEST)) {
$isPostback = TRUE;
}
if ($isPostback) {
$person_id = $_SESSION["LoggedOnPersonI
d"];
$password = getRequestValue("password"
);
$firstname = getRequestValue("firstname
");
$middlename = getRequestValue("middlenam
e");
$lastname = getRequestValue("lastname"
);
$employer = getRequestValue("employer"
);
$graduation_date = getRequestValue("graduatio
n_date");
$subnewsletter = getRequestValue("subnewsle
tter");
$email_address = getRequestValue("email_add
ress");
$phone_number = getRequestValue("phone_num
ber");
$validated = true;
if ($validated) {
$sql = Array();
$res = Array();
$last_ids = Array();
$delquery = Array();
$sql[0] = "UPDATE person SET password = '$password', firstname = '$firstname', middlename = '$middlename', lastname = '$lastname' WHERE person_id = '$person_id'";
$sql[1] = "UPDATE member SET employer = '$employer', graduation_date = '$graduation_date', subnewsletter = '$subnewsletter', email_address = '$email_address' WHERE person_id = '$person_id'";
$sql[2] = "UPDATE phone SET phone_number = '$phone_number' WHERE person_id = '$person_id'";
$delquery[0] = "DELETE FROM person WHERE person_id = ";
$delquery[1] = "DELETE FROM member WHERE person_id = ";
$delquery[2] = "DELETE FROM phone WHERE phone_id = ";
// print_r ($sql);
$conn = getConnection();
$feedback = "Member updated successfully.";
for ($i = 0; $i < count($sql); ++$i) {
$res[$i] = mysql_query($sql[$i], $conn);
$last_ids[$i] = mysql_insert_id($conn);
if (!$res[$i]) {
$err = mysql_error ($conn);
for ($j = $i-1; $j >= 0; -- $j) {
mysql_query($delquery[$j] . $last_ids[$j]);
}
$feedback = "Error, unable to update database: <br />$err";
break;
}
}
}
echo $feedback;
}
?>
Thank you for any help. :-)
Start Free Trial
