Anonymous

 <?php$link = mysql_connect("localhost", "user", "pass") or die        (mysql_error());        mysql_connect("database1") 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 Databse</center></h2>    <table width='70%' border='1' cellpadding='2' cellspacing='2' align='center'>      <tr>        <th align='left'>Movie Title</th>        <th align='left'>Movie Director</th>        <th align='left'>Movie Lead Actor</th>      </tr>EOD;    while($rows = mysql_fetch_array($result))    {        $movie_name = $row['movie_name'];        $movie_director = $row['movie_director'];        $movie_leadactor = $row['movie_leadactor'];                    $movie_details .=<<<EOD        <tr>            <td>$movie_name</td>            <td>$movie_director</td>            <td>$movie_leadactor</td>        </tr>            EOD;            }        $movie_details .=<<<EOD    <tr>        <td>&nbsp;</td>    </tr>    <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;                echo $movie;        ?>