Re: Ranking function in PHP/MySQL

macca wrote:
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";

}


The most stoopid argument I've seen in this group in ages.

The question was about how to do something in SQL. The answer was how to do it in SQL.

Wrapping some stupid *** like this around it does not make it a PHP question.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Quantcast