MYSQL cannot be updated

MYSQL cannot be updated

Please Help...This is my first attempt to php... I have tried to echo the
$id, $firstname etc. and it does echo the correct results, but the
database cannot be updated. I dunno what's wrong...
Here is "profile.php"
<?
include("common.php");
include("header.php");
?>
<td><table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="145" align="left" valign="top"><script
type="text/javascript" src="menu.js"></script></td>
<td width="50" align="left" valign="top"><img
src="images/header/divided1.jpg" width="40" height="473" /></td>
<td align="left" valign="top">
<? $link = mysql_connect("localhost", "root", "password");
mysql_select_db("test");
$email = $_SESSION['email'];
$sql = "SELECT * FROM fmcmember where email='$email'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result); ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="form4" method="post" action="update.php">
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="200" class="title">My Profile</td>
<td width="300" class="title">
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="id" type="hidden" value="<? echo $row[0] ?>"
size="30"/></td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="email">Email</td>
<td class="email"><? echo $row[6] ?></td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Firstname</td>
<td><input name="firstname" type="text" class="inputfield"
value="<? echo $row[1] ?>" size="30" maxlength="40" /></td>
<? if($row[3] == "M") { ?>
<td rowspan="16" align="left" valign="top">
<img src="images/myinfo/male.png" width="200" height="200" /></td>
<? } else { ?>
<td rowspan="16" align="left" valign="top">
<img src="images/myinfo/female.jpg" width="200" height="200" /></td>
<? } ?>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Lastname</td>
<td><input name="lastname" type="text" class="inputfield"
value="<? echo $row[2] ?>" size="30" maxlength="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Gender</td>
<td class="content">
<input name="gender" type="radio" value="M" <? if($row[3] ==
"M") { echo "checked"; }?> />Male
<input name="gender" type="radio" value="F" <? if($row[3] ==
"F") { echo "checked"; }?> />Female</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Date of birth</td>
<td><input name="dob" type="text" class="inputfield" value="<?
echo $row[4] ?>" size="30" maxlength="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Address</td>
<td><input name="address" type="text" class="inputfield" value="<?
echo $row[5] ?>" size="30" maxlength="200" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Tel</td>
<td><input name="tel" type="text" class="inputfield" value="<?
echo $row[7] ?>" size="30" maxlength="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Fax</td>
<td><input name="fax" type="text" class="inputfield" value="<?
echo $row[8] ?>" size="30" maxlength="40" /></td>
</tr>
<tr>
<td class="content">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="Update" type="submit" value="Update" />
<input name="Reset" type="button" value="Reset"
onclick="javascript:document.location.href='profile.php?action=reset'"/></td>
<td>&nbsp;</td>
</tr>
</form>
</table></td>
</tr>
</table></td>
<?
include("footer.php");
?>
update.php
<?
include("common.php");
//"¾"žregister.php •\šd"IÉŸ
$id = $_POST["id"];
$firstname = $_POST["firstname"];
$lastname = $_POST["lastname"];
$gender = $_POST["gender"];
$dob = $_POST["dob"];
$address = $_POST["address"];
$tel = $_POST["tel"];
$fax = $_POST["fax"];
$link = mysql_connect("localhost", "root", "password");
mysql_select_db("test");
mysql_query($sql, $link);
$sql = "update fmcmember set firstname='$firstname', lastname='$lastname',
gender='$gender', dob='$dob', address='$address', tel='$tel', fax='$fax'
where id='$id'";
include("header.php");
?>
<td><table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="145" align="left" valign="top"><script
type="text/javascript" src="menu.js"></script></td>
<td width="50" align="left" valign="top"><img
src="images/header/divided1.jpg" width="40" height="473" /></td>
<td align="left" valign="top"><table width="100%" align="left"
valign="top" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="300"><table width="100%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td class="title">&nbsp;</td>
</tr>
<tr>
<td class="title">My Profile</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td class="content">Your profile has been updated. Please
return back to <a href="profile.php">my profile</a> page.</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<?
include("footer.php");
?>