I have the following code:
<?php
$link=mysql_connect("localhost","root","")
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;
$movie_details='';
while ($row = 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> </td>
</tr>
<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;
?>
DW shows syntax error on line 60 : which is "echo $movie:"
when I remark the line, syntax doesn't go away so I know its not related to this line. When I delete the line, the error goes to the previous line. When I run in browser, I get:
Parse error: syntax error, unexpected end of file in C:\wamp\www\test2\table2.php on line 60
I suspect that I missed something. Please help!
Thanks