Easy Math Question

[DisOrDeR1337]

How can I add a number up when I am in a while()?
Lets say that there are 4 entries for $myrow[0]. 10, 20, 30 and 40. The total of those numbers is 100 right? So how do I output that?

$result = mysql_query("SELECT * FROM yada  ORDER BY id DESC",$db);
while ($myrow = mysql_fetch_row($result)) {	


$totalofmyrow = $myrow[0] + itself?????


}

echo $totalofmyrow;

Thanks

Aaron

[bpat1434]

$var++
That increments a variable:

$totalofmyrow = 0; // Or 1, whichever you want to start at
while($myrow = mysql_fetch_array($result))
{
  $totalofmyrow++;
}

Of course, if you just want to get the total number of rows returned (seems what you want to do), just use the function [man]mysql_num_rows/man

~Brett

[laserlight]

$result = mysql_query("SELECT * FROM yada  ORDER BY id DESC", $db);
$total = 0;
while ($myrow = mysql_fetch_row($result)) {    

	$total += $myrow[0];
}
echo $total;

If the array already exists and is a one dimensional array, you can use [man]array_sum/man instead.

[DisOrDeR1337]

laserlight hit it on the money, thanks!

[bpat1434]

Woops... misunderstood the question.... deleted above post....

[DisOrDeR1337]

Now, lets say that $myrow0 is 24hour time. and I have values like 0320 and 0240

Now with time we know that that is going to be 0600 hours right? not. 0560.

Is there anyway to do this?

[laserlight]

Ah, but now it is a little tricky. One obvious solution is to change the 24 hour clock format to time in minutes since the start of the day... but what do you want to do if the sum exceeds 24 hours?

[DisOrDeR1337]

just keep a running tab on what the total hours are. this is something im writing to keep track of how many hours i spend out of town so i can just take it to my tax lady and give her the total.

[laserlight]

Offhand, you could try something like:

function convertToMinutes($time) {
	return substr($time, 0, 2) * 60 + substr($time, 2);
}

$result = mysql_query("SELECT * FROM yada  ORDER BY id DESC", $db);
$hours = 0;
$minutes = 0;
while ($myrow = mysql_fetch_row($result)) {
	$minutes += convertToMinutes($myrow[0]);
	$hours += floor($minutes / 60);
	$minutes %= 60;
}

[DisOrDeR1337]

hmmm, outputs 0... lemme toy with it.

[DisOrDeR1337]

you really are a genius

[DisOrDeR1337]

would you happen to have a shortcut link to the += and %= functions?

[laserlight]

Basically,
$a = $a + $b;
can be written as:
$a += $b;
the same applies for %.