Get Previous Row

[Canman2005]

Hi all

 

I have the following QUERY

 

$sql = "SELECT bm.who, pl.bmid , COUNT( * ) AS `score` FROM log pl JOIN usr bm ON pl.bmid = bm.id GROUP BY pl.bmid ORDER BY `score` DESC";
$show = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($show))
{
print 'Total: '.$row['score'];
}

 

This works great.

 

My question is, how can I get the previous`score`, so I can do something like

 

Total: 100

Previous:

 

Total: 75

Previous: 100

 

Total: 50

Previous: 75

 

Total: 25

Previous: 50

 

I tried doing it using

 

LIMIT

 

but I can only get the next rows score and not the previous score.

 

Can anyone help?

 

Thanks tons in advance

 

Dave

[Psycho]

$previous = 0;
while ($row = mysql_fetch_array($show))
{
    print "Total: {$row['score']}<br />\n";
    print "Previous: {$previous}<br /><br />\n";
    $previous = $row['score'];
}

[Canman2005]

thanks man, worked lovely