add variable(s) from while() loop

[thebighere]

Hey,

I'm trying to add variables from a query result, and am not sure how to add the same variable (different values, same variable) to itself as many times as it occurs, and reach a sum total.

Hopefully that makes enough sense, but here's the example:

Basically:

while ($db->next_record()){
print $mrc;
}

Now, $mrc (a dollar amount) will come up many times, with a different value each time.

How do I add up the value of each mrc with all the other values of mrc?

Do I count and somehow use those results?

Possibly make an array of some sort and explode it?

I am a newbie, but I have scoured the manual and these forums, so hopefully I have not missed an obvious answer somewhere.

And hopefully this is the right forum...

thanks very much

[Sxooter]

Actually, this is a job for your database. Not that you can't do it in code, but since the database already knows how to do this stuff, you might as well let it.

Fer instance, let's say your query is something like this:

select mrc from table where id=1

And you are gonna print it out with the while loop. After the while loop, just run another query:

select sum(mrc) as mrcsum from table where id=1 group by mrc

Then just output the mrcsum as the next line.

Barring that, the way to add it up yourself is like so:

$sum=0;
while (...){
    $sum+=$mrc;
    print $mrc;
}
print $sum;

[thebighere]

thank you sooooooo much, that was a great fix

of course, now i feel like an idiot, but it's fixed!

thanks again

[Sxooter]

Nah, you're not an idiot. Newbie yes, idiot no.

Newbies ask questions,
idiots don't