DanielStead Posted December 12, 2005 Share Posted December 12, 2005 hi can anyone suggest a link or a method to how i would do this? I want to do an sql statement that selects say for example the column pages and adds up all the pages in the column for example id pages 1 2 2 4 3 8 4 10 The total number of pages should then be 24 (2+4+8+10) anyone got any ideas seems simple but cant find anywhere that tells me how to do it Link to comment https://forums.phpfreaks.com/topic/3026-calcuate-the-total-number-from-a-particular-column/ Share on other sites More sharing options...
fenway Posted December 24, 2005 Share Posted December 24, 2005 Try using the SUM() function: SELECT SUM(pages) FROM pages_table Hope that helps. Link to comment https://forums.phpfreaks.com/topic/3026-calcuate-the-total-number-from-a-particular-column/#findComment-10372 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.