connectDB(); $query = "UPDATE Users ". "SET password = '$password', first_name = '$firstName', last_name = '$lastName', address= '$address', city = '$city', state_id = $state, zip_code = '$zipCode', home_phone = '$homePhone', cell_phone = '$cellPhone', email = '$email' ". "WHERE unique_id = $currentUserID;"; $database->queryDB($query); $database->closeDB(); echo '

User Info Updated

'; } ?>

connectDB(); $query = "SELECT u.unique_id,u.username,u.first_name,u.last_name,u.address,u.city,s.abbrev,s.unique_id AS state_id,u.home_phone,u.cell_phone,u.email,u.zip_code ". "FROM Users AS u, States AS s WHERE u.state_id = s.unique_id ". "ORDER BY u.first_name, u.last_name;"; $result = $database->queryDB($query); echo ''. ''. ''. ''. ''. ''. ''. ''; while($line = mysql_fetch_array($result,MYSQL_ASSOC)) { $userID = $line["unique_id"]; $username = $line["username"]; $firstName = $line["first_name"]; $lastName = $line["last_name"]; $name = $line["first_name"]." ".$line["last_name"]; $zipCode = ($line["zip_code"] == "")?" ":$line["zip_code"]; $address = $line["address"]; $city = $line["city"]; $state = $line["state_id"]; $completeAddress = $address."
".$city.", ".$line["abbrev"]." $zipCode"; $completeAddress = ($completeAddress == "")?" ":$completeAddress; $homePhone = ($line["home_phone"] == "")?" ":$line["home_phone"]; $cellPhone = ($line["cell_phone"] == "")?" ":$line["cell_phone"]; $email = $line["email"]; $emailLink = "'.$line["email"].""; if($currentUserID == $userID || $currentUserID == 1) { echo ''. "". "". "". "". "". "". ''. '". '". '". '". '". '". '". '". '". '". '"; } else { echo "". "". "". "". "". "". ""; } }//while echo '

User Identity	Name	Address	Home Phone	Cell Phone	Email
$username	$name	$completeAddress	$homePhone	$cellPhone	$emailLink
$username	$name	$completeAddress	$homePhone	$cellPhone	$emailLink

'; $database->closeDB(); ?>