Hi, how can I summarize all user balances in the database, PHP?


I have tried this but not working:

$query = $this->db->prepare("SELECT SUM(balance) FROM Users GROUP BY email";
$query->execute();


thanks in advance

Syntaxbyte:
Hi, how can I summarize all user balances in the database, PHP?


I have tried this but not working:

$query = $this->db->prepare("SELECT SUM(balance) FROM Users GROUP BY email";
$query->execute();


thanks in advance

Wait. You mean in your users table, you also included a column called balance?

nnamdiosu:


Wait. You mean in your users table, you also included a column called balance?

Yes, it fixed.