Member Avatar for Smudly

Hi,

I have downloads that are available for users. They can click the links to download the file. Once they do this, I have a query that updates the number of downloads that file has received. I need to create a query that adds up all the rows Total Downloads.

So for example: i have 3 rows:
Name - Total Downloads
First - 2
Second - 23
Third - 7

Using the query for these rows would give me an amount of 32.

Any idea how to do this?

I don't want to have to create a new column to find the total number of downloads. Any other ways?

  • 2 Contributors
  • 1 Reply
  • 77 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mschroeder
Member Avatar for mschroeder 
SELECT SUM( table.column ) as `downloads`

Without more information that is as specific as I can get

Edited by mschroeder because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.