<?php
  $link\; =\; mysql\_connect("localhost","bp5am","bp5ampass")\; or\; die(mysql\_error());\; mysql\_select\_db("moviesite")\; or\; die\; (mysql\_error());$query = "SELECT movie_id, movie_name, " .
           "movie_director, movie_leadactor " .
           "FROM movie";
  
  $result\; =\; mysql\_query($query, $link)\; or\; die(mysql\_error());$num_movies = mysql_num_rows($result);$movie_header=<<<EOD
    <h2><center>Movie Review Database</center></h2>
    <table width="70%" border="1" cellpadding="2"
           cellspacing="2" align="center">
      <tr>
        <th>Movie Title</th>
        <th>Movie Director</th>
        <th>Movie Lead Actor</th>
      </tr>
       
  EOD;
  
  function get_director() {
    global $movie\_director;\; global$director;
  
    $query\_d\; =\; "SELECT\; people\_fullname\; "\; .\; "FROM\; people\; "\; .\; "WHERE\; people\_id=\text{'}$movie_director'";
    $results\_d\; =\; mysql\_query($query_d) 
      or die(mysql_error());
    $row\_d\; =\; mysql\_fetch\_array($results_d);
    extract($row\_d);$director = $people\_fullname;\; \}\; function\; get\_leadactor()\; \{\; global$movie_leadactor;
    global $leadactor;$query_a = "SELECT people_fullname " .
               "FROM people " .
               "WHERE people_id='$movie\_leadactor\text{'}";$results_a = mysql_query($query\_a)\; or\; die(mysql\_error());$row_a = mysql_fetch_array($results\_a);\; extract($row_a);
    $leadactor\; =$people_fullname;
  }
  
  $movie\_details\; =\; \text{'}\text{'};\; while\; ($row = mysql_fetch_array($result))\; \{$movie_id = $row[\text{'}movie\_id\text{'}];$movie_name = $row[\text{'}movie\_name\text{'}];$movie_director = $row[\text{'}movie\_director\text{'}];$movie_leadactor = $row[\text{'}movie\_leadactor\text{'}];$//get director's name from people table
    get_director();
  
    //get lead actor's name from people table
    get_leadactor();
  
    movie_details .=<<<EOD
    <tr>
      <td><a href="movie_details.php?movie_id=$movie\_id"\; title="Find\; out\; more\; about$movie_name">$movie\_name$</td>
      <td>director</td>
      <td>$leadactor$</td>
    </tr>
  EOD;
  }
  movie_footer ="</table>";     
       
  movie_header
                 $movie\_details$movie_footer
  MOVIE;
  
    echo "There are $num\_movies\; movies\; in\; our\; database";\; echo$movie;
  ?>