// To squelch undefined variable warnings if no record found
$user = null;
$query = "select username from users where id=$id";
$result = mysql_query($query);
if ($row = mysql_result($result)) { $user = $row['username']; } // or $row[0], in this case
echo '<p><label for="username">User Name:</label> <input type="text" name="username" id="username" value="' . $user . '"></p>';
... then update the record on submit, it will user whatever is in the database on the next page. If you don't want this value edited on the next page,
$user = null;
$step = (isset($_POST['username']) and ! empty($_POST['username'))?1:2;
// if 1, update or insert HERE
$query = "select username from users where id=$id";
$result = mysql_query($query);
if ($row = mysql_result($result) { $user = $row['username']; } // or $row[0], in this case
if ($step==2) {
echo "<p><strong>User Name:</strong> $user </p>";
}
else {
echo '<p><label for="username">User Name:</label> <input type="text" name="username" id="username" value="' . $user . '"></p>';
}
A simplified example as you'd also use the step and username combination as an error handler, but that's the idea.
