Help getting a total?

[lostinbass75]

I need help getting a total for multiple entries in a db.

I have pay_date = 18.24 in one row
the next is pay_date = 71.82
and so one..
How do I get the total(added up) for all the pay_date column entries?

[toplay]

Use SUM(pay_date) with your select query. See manual page:

http://dev.mysql.com/doc/mysql/en/group-by-functions.html#id2700508

.