Loop with MySQL problem

[Anon]

Hi,

I was just having a bit of trouble with some PHP looping throughout a MySQL database. Here's my situation at hand:

I have a table in my database of files. Each file has it's own name, description, etc. and it's own increasing, unique "ID". My question is:
How can I loop through each file entry and calculate the total number of file downloads from each of the files combined?

I hope I explained that well enough. 🙂

Thanks in advance,

Andrew Freiday

[vandalite]

SELECT SUM(download_field) AS files_total FROM table;

Is this what you're wanting?

[[deleted]]

Probably not.

IF you are after the number of times a certain filename appears in your database you can do

SELECT count(*) FROM table WHERE filename_field='filename';

But you'd have to run that query for every filename, which could be hundreds.
With a simple command you can make SQL do it all:

SELECT count(*),filename_field FROM table GROUP BY filename_field ORDER BY filename_field ASC;

This will give you a list like
5 doom.exe
5767 gimme_more_coffe.tgz
23 php.exe

You can add limits to the query to get only report for the number of downloads over s certain timeframe etc.