pleaase i am a beginner with php and i ve been battling with this code.it requires displaying rows of data from a database.At the moment i can only display the table headings .please i appreciate your help to display the rows as well.thanks in advance.Duke
//code follows
<?php
$link = mysql_connect("localhost","root","password") or die( mysql_error());
//make sure the database is selected
mysql_select_db("moviesite") or die(mysql_error());
/ Function to calculate if a movie made profit
loss or broken even/
function calculate_differences($takings,$cost){
$difference = $takings - $cost;
if($difference <0){
$difference = substr($difference,1);
$font_color = red;
$profit_or_loss ="$". $difference ."m";
}elseif($difference >0){
$font_color = green;
$profit_or_loss ="$". $difference ."m";
}else{
$font_color = blue;
$profit_or_loss ="Broke even";
}
return "<font color=\"$font_color\">" .$profit_or_loss ."</font>";
}
/ function to get the directors name from the people table /
function get_director(){
global $movie_director;
global $director;
$query_d ="SELECT people_fullname ".
" FROM people ".
" where people_id = '$movie_director' ";
$result_d = mysql_query($query_d) or die(mysql_error());
$rows_d = mysql_fetch_array($result_d);
extract($rows_d);
$director=$people_fullname;
}
/ functon to get the leadactor name from the people table /
function get_leadactor(){
global $movie_leadactor;
global $leadactor;
$query_a ="SELECT people_fullname ".
" FROM people ".
" where people_id ='$movie_leadactor' ";
$result_a = mysql_query($query_a) or die(mysql_error());
$rows_a = mysql_fetch_array($result_a);
extract($rows_a);
$leadactor = $people_fullname;
}
$movie_query = "SELECT * FROM movie " .
" WHERE movie_id = '" .$_GET['movie_id'] ."'";
$movie_result = mysql_query($movie_query,$link) or die( mysql_error());
$movie_table_headings=<<<EOD
<tr>
<th>Movie Title</th>
<th>Year Of Release</th>
<th>Movie Director</th>
<th>Movie Leadactor</th>
<th>Movie Running Time</th>
<th>Movie Health</th>
</tr>
EOD;
while ($row = mysql_fetch_array($movie_result)) {
$movie_name = $row['movie_name'];
$movie_director = $row['movie_director'];
$movie_leadactor = $row['movie_leadactor'];
$movie_year = $row['movie_year'];
$movie_running_time = $row['movie_running_time']." mins";
$movie_takings = $row['movie_takings'];
$movie_cost = $row['movie_cost'];
//get director’s name from people table
get_director();
//get lead actor’s name from people table
get_leadactor();
}
$review_query = "SELECT * FROM reviews ".
"WHERE review_movie_id = '".$_GET['movie_id'] . "'".
"ORDER BY review_date DESC";
$review_result = mysql_query($review_query,$link) or die(mysql_error());
$movie_health=calculate_differences($movie_takings, $movie_cost);
$page_start =<<<EOD
<html>
<head>
<title>Details and Reviews for: $movie_name</title>
</head>
<body>
EOD;
$movie_details =<<<EOD
<table width="70%" border="0" cellspacing="2"
cellpadding="2" align="center">
<tr>
<th colspan="6"><u><h2>$movie_name: Details</h2></u></th>
</tr>
$movie_table_headings
<tr>
<td width="33%" align="center">$movie_name</td>
<td align="center">$movie_year</td>
<td align="center">$director</td>
<td align="center">$leadactor</td>
<td align="center">$movie_running_time</td>
<td align="center">$movie_health</td>
</tr>
</table>
<br>
<br>
EOD;
$review_table_headings =<<<EOD
<tr>
<th>Date of Review</th>
<th>Review Title</th>
<th>Reviewer Name</th>
<th>Movie Review Comments</th>
<th>Rating</th>
</tr>
EOD;
while($review_row = mysql_fetch_array($review_result)){
$review_flag = 1;
$review_title[] = $review_row['review_name'];
$reviewer_name[]= ucwords($review_row['review_reviewer_name']);
$review[] = $review_row['review_comment'];
$review_date[] = $review_row['review_date'];
$review_rating[] = generate_ratings($review_row['review_rating']);
}
if($review_flag) {
$movie_details .=<<<EOD
<table width="95%" border="0" cellspacing="2"
cellpadding="20" align="center">
$review_table_headings
$review_details
</table>
EOD;
}
$page_end =<<<EOD
</body>
</html>
EOD;
$detailed_movie_info =<<<EOD
$page_start
$movie_details
$page_end
EOD;
echo $detailed_movie_info;
mysql_close();
$i=0;
$review_details ='';
while($i<sizeof($review)) {
$review_details .=<<<EOD
<tr>
<td width="15%" valign="top" align="center">$review_date[$i]</td>
<td width="15%" valign="top">$review_title[$i]</td>
<td width="10%" valign="top">$reviewer_name[$i]</td>
<td width="50%" valign="top">$review[$i]</td>
<td width="10%" valign="top" align="center">$review_rating[$i]</td>
</tr>
EOD;
$i++;
}
Function generate_ratings($review_rating){
$movie_rating ='';
for($i=0;$i<$review_rating;$i++){
$movie_rating .="<img src=\"thumbsup.gif\"> ";
}
return $movie_rating;
}
?>
