帮我看看哪里错了.谢谢

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php
$db=mysql_connect("localhost","root","xiaozhuo") or die ('Unable connected Mysql');
mysql_select_db('moviesite',$db);if($_GET['action']=='edit'){
$query='select movie_name,movie_type,movie_year,movie_leadactor,movie_director from movie where movie_id='.$_GET['id'];
$result=mysql_query($query,$db);
extract(mysql_fetch_assoc($result));
}else{$movie_name='';
  $movie_type=0;
  $movie_year=date('Y');
  $movie_leadactor=0;
  $movie_director=0;
}?><meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><?php echo ucfirst($_GET['action']).' '; ?>movie</title>
</head><body>
<form  method="POST" action="commit.php?action=<?php echo $_GET['action']; ?>&type=movie">
  <table width="280" height="205" border="0">
    <tr>
      <td width="83">Movie Name</td>
      <td width="187"><label>
        <input type="text" name="movie_name" value="<?php echo $movie_name; ?>"/>
      </label></td>
    </tr>
    <tr>
      <td>Moive Type</td>
      <td><label>
        <select name="movie_type">
        <?php 
$query='select movietype_id,movietype_label from movietype order by movietype_label';
$result=mysql_query($query,$db) or die ('连接失败');
while($row=mysql_fetch_assoc($result))
{
if($row['movietype_id']==$movie_type){
echo '<option value="'.$row['movietype_id'].'" selected="selected">';
}else{
echo '<option value="'.$row['movietype_id'].'">';
}
echo $row['movieytpe_label'].'</option>';
?>
        </select>
      </label></td>
    </tr>
    <tr>
      <td>Movie Year</td>
      <td><select name="movie_year">
      <?php   for($year=date('Y');$year>=1970;$year--)
   {
 if($year==$movie_year){
echo '<option value="'.$year.'" selected="selected">'.$year.'</option>';
}else{echo '<option value="'.$year.'">'.$year.'</option>';
if($year%10==0){
echo '<option value="----">----</option>';
}
}
}
  ?>
      </select></td>
    </tr>
    <tr>
      <td>Lead Actor</td>
      <td><select name="movie_leadactor">
      <?php
      $query='select people_id,people_fullname from people where people_isactor=1 order by people_fullname';
  $result=mysql_query($query,$db);
  while($row=mysql_fetch_assoc($result))
   {
//echo '<option value="'.$row['people_id'].'">'.$row['people_fullname'].'</option>';
if($row['people_id']==$movie_leadactor){
echo '<option value="'.$row['people_id'].'" selected="selected">';
}else{
echo '<option value="'.$row['people_id'].'">';
}
echo $row['people_fullname'].'</option>';
}
  ?>
      
      </select></td>
    </tr>
    <tr>
      <td>Director</td>
      <td><select name="movie_director">
      <?php
$query='select people_id,people_fullname from people where people_isdirector=1 order by people_fullname';
$result=mysql_query($query,$db) or die (mysql_error($db));while($row=mysql_fetch_assoc($result)){
//echo '<option value='.$row['people_id'].'">'.$row['people_fullname'].'</option>';
if($row['people_id']==$movie_director){
echo '<option value="'.$row['people_id'].'" selected="selected">';
}else{
echo '<option value="'.$row['people_id'].'">';
}
echo $row['people_fullname'].'</option>';
}
?>
      </select></td>
    </tr>
    <tr>
      <td colspan="2" style="text-align:center"><label>
        <?php
        if($_GET['action']=='edit'){
echo '<input type="hidden" value="'.$_GET['id'].'name="movie_id" />';
}
?>
<input type="submit" name="submit" value="<?php echo ucfirst($_GET['action']);?>" />
  </label></td>
    </tr>
  </table>
</form>
</body>
</html>