Hello MySQL Gurus,
I have a simple query question.
For the sake of simplicity, let's imagine this is my table of results.
user_id amount 1 20 1 24 2 32 3 55
When I output this data using a while or foreach loop, how can I merge the rows that have the same user_id and also add it's amount to one value. So it displays something like this:
1 Total amount: 44 2 Total amount: 24 3 Total amount: 55
Thank you :)