Updating Rows via Form

[CraniumDesigns]

Here's my code:

$first_name = $_SESSION['first_name'];
$last_name = $_SESSION['last_name'];
$sql = mysql_query("SELECT * FROM roster WHERE first_name = '$first_name' AND last_name = '$last_name'");
$person = mysql_fetch_array($sql);

echo "<table cellpadding=3 border=1>";

echo "<tr><td><b>First Name:</b></td><td>".$person[first_name]."</td></tr>";
echo "<tr><td><b>Last Name:</b></td><td>".$person[last_name]."</td></tr>";
echo "<tr><td><b>Street:</b></td><td><input type=textfield value='".$person[street]."'></td></tr>";
echo "<tr><td><b>City:</b></td><td><input type=textfield value='".$person[city]."'></td></tr>";
echo "<tr><td><b>State:</b></td><td><input type=textfield value='".$person[state]."'></td></tr>";
echo "<tr><td><b>Zipcode:</b></td><td><input type=textfield value='".$person[zipcode]."'></td></tr>";
echo "<tr><td><b>Birth Date:</b></td><td>".$person[dob]."</td></tr>";
echo "<tr><td><b>Phone:</b></td><td><input type=textfield value='".$person[phone]."'></td></tr>";
echo "<tr><td><b>Email Address:</b></td><td><input type=textfield value='".$person[email]."'></td></tr>";
echo "<tr><td><b>AIM SN:</b></td><td><input type=textfield value='".$person[aim]."'></td></tr>";
echo "<tr><td><b>Major:</b></td><td><input type=textfield value='".$person[major]."'></td></tr>";

echo "</table>";

How do I turn it into a form where it actually updates the mysql database? Please modify my code to show. THANK YOU!

[CraniumDesigns]

nevermind. i figured it out on my own. here's my code if anyone's interested.

$first_name = $_SESSION['first_name'];
$last_name = $_SESSION['last_name'];

if($_POST[aim] != "") {
	$street = $_POST[street];
	$city = $_POST[city];
	$state = $_POST[state];
	$zipcode = $_POST[zipcode];
	$phone = $_POST[phone];
	$email = $_POST[email];
	$aim = $_POST[aim];
	$major = $_POST[major];

$update = mysql_query("UPDATE roster SET street = '$street', city = '$city', state = '$state', zipcode = '$zipcode', phone = '$phone', email = '$email', aim = '$aim', major = '$major' WHERE first_name = '$first_name' AND 'last_name' = 'last_name' LIMIT 1");

echo "<font color=red>Updated!</font>";

}

$sql = mysql_query("SELECT * FROM roster WHERE first_name = '$first_name' AND last_name = '$last_name'");
$person = mysql_fetch_array($sql);
$date = date("n/j/Y", strtotime($person[dob]));

echo "<form action=$_SERVER[PHP_SELF] method=post><table cellpadding=3 border=1>";

echo "<tr><td><b>First Name:</b></td><td>".$person[first_name]."</td></tr>";
echo "<tr><td><b>Last Name:</b></td><td>".$person[last_name]."</td></tr>";
echo "<tr><td><b>Street:</b></td><td><input type=text name=street value='".$person[street]."'></td></tr>";
echo "<tr><td><b>City:</b></td><td><input type=text name=city value='".$person[city]."'></td></tr>";
echo "<tr><td><b>State:</b></td><td><input type=text name=state value='".$person[state]."'></td></tr>";
echo "<tr><td><b>Zipcode:</b></td><td><input type=text name=zipcode value='".$person[zipcode]."'></td></tr>";
echo "<tr><td><b>Birth Date:</b></td><td>".$date."</td></tr>";
echo "<tr><td><b>Phone:</b></td><td><input type=text name=phone value='".$person[phone]."'></td></tr>";
echo "<tr><td><b>Email Address:</b></td><td><input type=text name=email value='".$person[email]."'></td></tr>";
echo "<tr><td><b>AIM SN:</b></td><td><input type=text name=aim value='".$person[aim]."'></td></tr>";
echo "<tr><td><b>Major:</b></td><td><input type=text name=major value='".$person[major]."'></td></tr>";
echo "<tr><td colspan=2><input type=submit value=Submit name=submit></td></tr>";

echo "</table></form>";