Chapter 3- Problem with this code

vickykumar · May 7th, 2012, 07:00 AM

I have run following code on my desktop. But the output is blank.
Output page is showing nothing.

Please point out my error in this code.

Quote:

<?php
$db = mysql_connect('localhost', 'root', '') or die ('Unable to connect. Check your conneciton parameters.');
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// select the movie titles and thier genre after 1990
$query = 'SELECT
movie_name, movie_type
FROM
movie
WHERE
movie_year > 1990
ORDER BY
movie_type';
$result = mysql_query($query, $db) or die(mysql_error($db));

// show the results as a foreach loop
while ($row = mysql_fetch_array($result))
{
foreach ($row as $value)
{
echo $value . ' ';
}
echo '<br>';
}
?>

UseLess · May 7th, 2012, 09:16 AM

Greetings,

Does the database table 'movie' have any data in it? If it does not then you'll see nothing on the page as there is nothing to show...

vickykumar · May 7th, 2012, 09:38 AM

yes, table movie have all data in database.
But its show nothing when i run this code.
does i need any mysql setting?

UseLess · May 7th, 2012, 04:03 PM

Greetings,

Try changing this:

Code:

while ($row = mysql_fetch_array($result))

to this:

Code:

while ($row = mysql_fetch_array($result,MYSQL_ASSOC))

or this:

Code:

while ($row = mysql_fetch_assoc($result))