<?php
    $link\; =\; mysql\_connect("localhost",\; "bp5am",\; "bp5ampass")\; or\; die("Could\; not\; connect:\; "\; .\; mysql\_error());\; mysql\_select\_db(\text{'}moviesite\text{'},$link) 
      or die ( mysql_error()); 
  // DELETE SCRIPT
    if (!isset($\_GET[\text{'}do\text{'}])\; ||$_GET['do'] != 1) {
  ?>
    <p align="center" style="color:#FF0000">
      Are you sure you want to delete this <?php 
      echo $\_GET[\text{'}type\text{'}];\; ?>?$<br>
      <a href="<?php echo _SERVER['REQUEST_URI']; ?>&do=1">yes</a> 
      or <a href=<index.php>>Index</a>
    </p>
  <?php
    } else {
      if ($\_GET[\text{'}type\text{'}]\; ==\; "people")\; \{$// delete references to people from the movie table
        // delete reference to lead actor
        actor = "UPDATE movie 
                  SET movie_leadactor = '0' 
                  WHERE movie_leadactor = '" . $\_GET[\text{'}id\text{'}]\; .\; "\text{'}";$result = mysql_query($actor)\; or\; die("Invalid\; query:\; "\; .\; mysql\_error());$// delete reference to director
        director = "UPDATE movie 
                     SET movie_director = '0'
                     WHERE movie_director = '" . $\_GET[\text{'}id\text{'}]\; .\; "\text{'}";$result = mysql_query($director)\; or\; die("Invalid\; query:\; "\; .\; mysql\_error());\; \}$// generate SQL
      sql = "DELETE FROM " . $\_GET[\text{'}type\text{'}]\; .\; "\; WHERE\; "\; .$_GET['type'] . "_id = '" . $\_GET[\text{'}id\text{'}]\; .\; "\text{'}\; LIMIT\; 1";$// echo SQL for debug purpose
      echo "<!--" . sql . "-->";
      $result\; =\; mysql\_query($sql)
        or die("Invalid query: " . mysql_error());
  ?>
    <p align="center" style="color:#FF0000">
      Your <?php echo </a>
    </p>
  <?php
    }
  ?>