table2.php in chapter 4

redarrow · February 16th, 2006, 05:08 AM

I figured I should put this in a new thread then someone may notice it ;)

table2.php in chapter 2 will simple not work for me, I just get a blank page.. all the other exercises up till this one have worked with no problem...

I've also tried the downloaded one, which does the same thing...

Any ideas anyone??

I've entered it as follows:

Code:

<?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;

$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>&nbsp;</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;

"Those who do not believe in magic will never find it" - Roald Dahl

redarrow · February 16th, 2006, 05:24 AM

Ok, I have just figured it out.. :D

Code:

mysql_select_db("moviesite");
    or die(mysql_error());

Notice the semi-colon after mysql_select_db("moviesite")
This is what happens when you don't have a compiler which complains about stupid mistakes like this

Strange thing is the downloaded version does not have this error, and yet it's still giving me a blank page..

"Those who do not believe in magic will never find it" - Roald Dahl

sandeepgreaternoida · April 13th, 2009, 07:27 PM

Quote:

Originally Posted by redarrow

Ok, I have just figured it out.. :D

Code:

mysql_select_db("moviesite");
    or die(mysql_error());

Notice the semi-colon after mysql_select_db("moviesite")
This is what happens when you don't have a compiler which complains about stupid mistakes like this

Strange thing is the downloaded version does not have this error, and yet it's still giving me a blank page..

"Those who do not believe in magic will never find it" - Roald Dahl

Is there any solution for chapter-4, table2-rev01.php it does not work in browser only i get the blank page ? others like table2-rev02.php and table3.php are working absolutely fine on the browser.
i think there must be some publishing mistake.
any way if u have got any solution any solution for that pls. let me know.