PHP Change Image Depending Upon Ranking Score +/-

[leonarmston]

Hi there in my ladder I want to display a up arrow if playerRankings.pRankingScore is great than playerRankings.pPrevRankingScore or down arrow if less & if the values are the same the display the yellow no change diamond. I would like to display the image in Points +/- column. I have saved the images below to my server and they are in /images under the same filenames. Just wondering if anybody could help me out with this simple if statement?

<?php
require('library/db_connect.php');	// database connect script.
?>
<?php include 'library/header.inc'; ?>


<?php

$query  = "SELECT playerRankings.pRankingsID, playerRankings.pRankingScore, playerRankings.pPrevRankingScore, users.username, users.playerName 
					 FROM playerRankings, users 
           WHERE (playerRankings.pRankingsID = users.username)
           ORDER BY playerRankings.pRankingScore DESC";

$result = mysql_query($query) or die('Error : ' . mysql_error()); 

print "<table border=1>\n<tr><th>Rank</th><th>Name</th><th>Score</th><th>Prev Score</th><th>Points +/-</th></tr>\n";

	$rank = 1;
while ($row = mysql_fetch_assoc($result)) {

print "<tr><td>{$rank}</td><td><a href=\"playerDetails.php?username=$row[username]\">$row[playerName]</a></td><td>{$row['pRankingScore']}</td><td>{$row['pPrevRankingScore']}</td><td></td><tr>\n";

$rank++;
}


print "</tr>" .
      "</table>";









$db_object->disconnect();
?>

<?php include 'library/footer.inc'; ?>

[n_wattam]

fill in the blanks to suit you. Place this code at the start of your table or top of your page, then goto normal html using the echo statement at the bottom where you want the image

<?
$score_new = '60';
$score_last = '45';

if ($score_new > $score_last) {
	 $image ='';
}

if ($score_new == $score_last) {
	 $image ='';
}

if ($score_new < $score_last) {
	 $image ='';
}
?>

<img src="<? echo $image; ?>">