Hi i am using this by the book and what ever i try to do dose not work.
<?php
$link = mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("moviesite");
$query = "SELECT movie_name, movie_director, movie_leadactor FROM movie";
$results = mysql_query($query, $link) or die (mysql_error());
$num_movies = mysql_num_rows($results);
$movie_header =<<<EOD
<h2><center>Movie Review Database</center></h2><table width='70%' border='1' cellpading='2' align='center'><tr><th>Movie Title</th>
<th>Year of Release</th>
<th>Movie Director</th>
<th>Movie Lead Actor</th>
<th>Movie Type</th>
</tr>
EOD;
$movie_details = '';
while ($row = mysql_fetch_array($results, $link)) {
$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;
?>
p.s
how to asign variables in sql
<?php
$connect = mysql_connect("localhost", "root", "password");
mysql_select_db("moviesite");
$offset=$_REQUEST['offset'];
$query='SELECT movie_name, movie_year FROM movie ORDER BY movie_year LIMIT " . $offset . " , 1 ';
$results = mysql_query($query) or die(mysql_error());
echo "<table>\n";
while ($rows=mysql_fetch_assoc($results)) {
echo "<tr>\n";
foreach($rows as $value) {
echo "<td>\n";
echo $value;
echo "</td>\n";
}
echo "</table>\n";
}
echo "<a href='page.php?offset=0'> Page 1</a><br>";
echo "<a href='page.php?offset=2'> Page 2</a><br>";
echo "<a href='page.php?offset=3'> Page 3</a><br>";
?> this dos not work to :/ did bythe book..
