hi,
can someone help me on this ive higlighted line 95 in red
<?php
$link = mysql_connect("***","****","*****") or die (mysql_error());
mysql_select_db("***") or die (mysql_error());
function calculate_costs($takings, $cost)
{
$difference = $takings - $cost;
if ($difference <0)
{
$difference = substr($difference,1);
$font_color = 'red';
$profit_or_loss ="$".$difference."m";
}
else if ($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 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;
}
$query = "SELECT *
FROM movie
WHERE movie_id ='".$_GET['movie_id']."'";
$result = mysql_query($query,$link) or die (mysql_error());
$movie_table_heading=<<<EOD
<tr>
<th>Movie Title</th>
<th>Year of Release</th>
<th>Movie Director</th>
<th>Movie Lead Actor</th>
<th>Movie Running Time</th>
<th>Movie Health</th>
<tr>
EOD;
while($row = mysql_fetch_array($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($movie_director);
get_leadactor($movie_leadactor);
} ?>