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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.