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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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.