Loop MySQL results

[NZ_Kiwis]

I want to loop though my database and group all my Staff ID's together..

What I'm doing is looping though each person (StaffID) and each time though I'm counting my certin rows (TotalCarsSold) (TotalRevenueMade) plus a few others, I want to count each person total and display each one.

HOw can I do this?

[NogDog]

Probably not enough info for me to say for sure, but it sounds like it might be a job for a GROUP BY in your DB query.