DB Values + Math 1

[TanTrazz]

Hi All,

Question:

Ive got these values in a MYSQL db.

ID Value
1 7250
2 9357
3 10258
4 18790

What i want to do is calculate the differences between 1 and 2, 2 and 3, 3 and 4 etc.

The output would be:
1 2107
2 901
3 8532

Does someone knows how to do this in PHP?

Does someone has an example?

TnQ

 

[jpadie]

$result = mysql_query("select `id`,`value` from table") or die(mysql_error());
while ($row =mysql_fetch_array($result)){
 $vals[$row[0]] = $row[1];
}
$n = count($vals);
for ($i=0; $i<($n-1); $i++){
 //handle last number
 $m = isset($vals[$i+1]) ? $vals[$i+1] - $vals[$i] : $vals[$i]; 
 echo ($i+1) . "\t$m<br/>\r\n";
}

 

[TanTrazz]

TnQ jpadie,

Im gonna try this!!!

Thank You