Jump to content

Archived

This topic is now archived and is closed to further replies.

xam

Get total downloads..

Recommended Posts

Hi everyone,

 

database7sd.gif\" border=\"0\" alt=\"IPB

 

Screenshoot will say everything What I need :)

 

E.g.: Total Downloads: 366

 

My best regards.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

[!--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 :)

 

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.