|
|
Posted by Jerry Stuckle on 10/07/07 13:36
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 shit 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@attglobal.net
==================
Navigation:
[Reply to this message]
|