TecTao Posted February 8, 2008 Share Posted February 8, 2008 I can't seem to find the function to sum a column of numbers. the column $pay_amount is monthly amounts for a program. My select statement for a particular member produces a table of with each program and amount the member has signed up for. I need to get the sum of the $pay_amount column. This is an easy one but I just can remember or find it in googling. Thanks, m Link to comment https://forums.phpfreaks.com/topic/90099-solved-sum-column-variables/ Share on other sites More sharing options...
pocobueno1388 Posted February 8, 2008 Share Posted February 8, 2008 Just use SUM. SELECT SUM(pay_amount) as total FROM table Link to comment https://forums.phpfreaks.com/topic/90099-solved-sum-column-variables/#findComment-461961 Share on other sites More sharing options...
TecTao Posted February 8, 2008 Author Share Posted February 8, 2008 I'm familiar with the sum (pay_amount) as total in the Sql statement. but since I am joining about 4 tables and the 'pay_amount' is not in the first table, I was hoping there was a command that could total the numbers in the column rather then write a sql statement. Link to comment https://forums.phpfreaks.com/topic/90099-solved-sum-column-variables/#findComment-462052 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.