PHP/MySQL Problem!

SpiderIRE · 10-18-2005, 03:49 PM

I'm not sure if this is the right place to post this, but its the closet one i could fine! this is the code: (its out of a PHP/MySQL book i'm using)

PHP Code:


			
<?php

$link = mysql_connect("localhost","user","pass") or die(mysql_error());

     mysql_select_db("wiley") 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;



function get_director() {

     global $movie_director;

     global $director;



     $query_d = "SELECT people_fullname

          FROM people

          WHERE people_id='$movie_director' ";

     $results_d = mysql_query($query_d) or die(mysql_error());

     $row_d = mysql_fetch_array($results_d);

     extract ($row_d);

     $director = $people_fullname;

}



function get_leadactor() {

     global $movie_leadactor;

     global $leadactor;



     $query_a = "SELECT people_fullname

          FROM people

          WHERE people_id='$movie_leadactor'";

     $results_a = mysql_query($query_a) or die(mysql_error());

     $row_a = mysql_fetch_array($results_a);

     extract ($row_a);

     $leadactor = $people_fullname;

}



while($row = mysql_fetch_array($result))

{

     $movie_name = $row['movie_name'];

     $movie_director = $row['movie_director'];

     $movie_leadactor = $row['movie_leadactor'];



     //get director's name from people table

     get_director($movie_director);



     //get lead actor's name from people table

     get_leadactor($movie_leadactor);



     $movie_details .=<<<EOD

     <tr>

          <td>$movie_name</td>

          <td>$director</td>

          <td>$leadactor</td>

     </tr>

EOD;

     }





$movie_details .=<<<EOD

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

?>

this doesn't work and doesn't give u any errors! i can't see the problem!! any help please????

Thanks
David

clb · 10-18-2005, 04:02 PM

Couple of suggestions at this point:
1. Try adding various echo("xxx"); statements throughout your code, that will help you to diagnose where the problems are
eg

PHP Code:


			
//Open connection to database server

echo("Connected to database<br />");

//Select database

echo("Database selected<br />");

2. Check that there are records to be displayed.

Quick note, if you enclose your php code in [P H P]xxx[/P H P] tags, just remove the spaces between the letters. This will format and colour your PHP code correctly, and make it much easier to read (like above).

Chris

SpiderIRE · 10-19-2005, 10:14 AM

so i edited the code to show the 'colours'!! (i.e. the [p h p]xxxx[/p h p] tags)! anyone have any ideas as to what is wrong with it??

Cheers,
David

ftenario · 10-19-2005, 11:24 AM

Since you maybe running this on your local machine, check your php.ini configuration to report all errors. That way, you get an idea on what is going on if there are errors