It seems i do more time debugging the code on this book than learning from it. Your codes just do not work. Why rush study books to market with lots of bugs.

Problem: Warning: extract() [function.extract]: First argument should be an array in /home/www.test.com/public_html/table2.php on line 37.

Im using Linux AS 4, Apache 1.33 , PHP 5.0.4 and MYSQL 5.04.
Code is listed below.


<?php
$link = mysql_connect("localhost","root","mysqlpass") or die(mysql_error());
     mysql_select_db("wiley") 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='$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'";
     $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($movie_director);

     //get lead actor's name from people table
     get_leadactor($movie_leadactor);

     $movie_details .=<<<EOD
     <tr>
          <td>$movie_name</td>
          <td>$director</td>
          <td>$leadactor</td>
     </tr>
EOD;
     }


$movie_details .=<<<EOD
<tr>
     <td>Total :$num_movies Movies</td>
</tr>
EOD;

$movie_footer ="</table>";

$movie =<<<MOVIE
               $movie_header
               $movie_details
               $movie_footer
MOVIE;

     print "There are $num_movies movies in our database";
     print $movie;
?>

yes these codes of table2-rev01.php is just very stupid they do not work....i have tried many times.........there must be some publishing error ..we must communicate this problem to the authors .

__________________
sandeep gupta