xam Posted January 14, 2006 Share Posted January 14, 2006 Hi everyone, Screenshoot will say everything What I need E.g.: Total Downloads: 366 My best regards. Link to comment https://forums.phpfreaks.com/topic/3199-get-total-downloads/ Share on other sites More sharing options...
fenway Posted January 14, 2006 Share Posted January 14, 2006 It's not a count, it's a sum. Strange-looking filenames, by the way. Try the following: SELECT SUM(downloads) FROM yourTable Hope that helps. Link to comment https://forums.phpfreaks.com/topic/3199-get-total-downloads/#findComment-10908 Share on other sites More sharing options...
xam Posted January 14, 2006 Author Share Posted January 14, 2006 [!--quoteo(post=336540:date=Jan 14 2006, 09:11 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 14 2006, 09:11 PM) 336540[/snapback][/div][div class=\'quotemain\'][!--quotec--] It's not a count, it's a sum. Strange-looking filenames, by the way. Try the following: SELECT SUM(downloads) FROM yourTable Hope that helps. I used this code for it SELECT SUM(downloads) AS 'total' FROM mytable Thank you, I find to right way with you Link to comment https://forums.phpfreaks.com/topic/3199-get-total-downloads/#findComment-10910 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.