The record in the table is found using the user id
I have this code which diplays the users info. I believe I need to assign the row values to variables so that I can set the form values
include 'db.php';
$username = $_SESSION['username'];
// note, if userid is not a numeric type column, then $userid must be quoted
$query = "SELECT * FROM users WHERE username = '$username'";
$result = @mysql_query($query);
if(!$result)
{
trigger_error("<p>SQL ERROR:<br>".mysql_error()."<br>Query: $query</p>",
E_USER_WARNING);
}
elseif(mysql_numrows($result) != 1)
{
trigger_error("<p>DB ERROR: There were multiple matches on this User ID</p>",
E_USER_WARNING);
}
else // we got exactly one match on the User ID
{
echo "<b><center>Database Output</center></b><br><br>";
// only 1 match, so we don't need a loop
$row = mysql_fetch_assoc($result);
extract($row, EXTR_PREFIX_ALL, "user");
mysql_close();
echo <<<END
<b>$user_first_name $user_last_name</b><br>
Date of Birth: $user_DOB<br>
<b>Address</b><br>
Street Address: $user_Street_address<br>
Other Mailing Information: $user_post_office_box<br>
City: $user_city <br>
Province: $user_province<br>
Postal Code: $user_postal<br>
Home Phone Number: $user_home_phone<br>
Email Address: $user_email_address<br>
Family Relationship: $user_familyRelationship<br>
<hr><br>
END;
}
?>