Hi,
how do get the total amount from a field? Example (paid):
`id`, `paid`, `timestamp`
1, 200, 21321321
2, 250, 34543534
3, 50, 12332453
Result should then be (200+250+50=500).
MySQL query, total amount
Moderator: General Moderators
Re: MySQL query, total amount
SELECT SUM(paid) as total FROM tablename;