<?php
  $link\; =\; mysql\_connect("localhost","bp5am","bp5ampass")\; or\; die(mysql\_error());\; mysql\_select\_db("moviesite")\; or\; die\; (mysql\_error());$query = "SELECT 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;
  }
  
  while ($row\; =\; mysql\_fetch\_array($result)) {
    $movie\_name\; =$row['movie_name']; 
    $movie\_director\; =$row['movie_director'];
    $movie\_leadactor\; =$row['movie_leadactor'];
       
    //get director's name from people table
    get_director();
  
    //get lead actor's name from people table
    get_leadactor();
  
    <tr>
      <td>movie_name</td>
      <td>$director$</td>
      <td>leadactor</td>
    </tr>
  EOD;
  }     
  
  <tr>
      <td>Total :num_movies Movies</td>
    </tr>
  EOD;
  
  $movie\_footer\; ="$</table>";     
       
  movie =<<<MOVIE
                 $movie\_header$movie_details
                 $movie\_footer\; MOVIE;\; echo\; "There\; are$num_movies movies in our database";
    echo $movie;\; ?>$