|
|
Posted by macca on 10/07/07 05:36
Just to insert some php in here to satisfy the die hards, in order to
display your ranking order you could do this:
$sql = "SELECT casualtyID, deathdate FROM the_table ORDER BY deathdate
ASC";
$result = mysql_query($sql,$connection) or die(mysql_error());
for ($i=0; $i < mysql_num_rows($result); $i++){
$casualtyID = mysql_result($result,$i,"casualtyID");
$death_date = mysql_result($result,$i,"deathdate");
$rank = $i+=1;
echo "$casualtyID is the number $rank casualty to die in the current
wars in Iraq and Afghanistan\n";
}
Navigation:
[Reply to this message]
|