[Resolved] count()

[tuf-web_co_uk]

probably a really easy question for someone whos been doing php for about a year

never the less

i wanted to know how i could add all of the fields in a table together

eg..

downloads table

Name | Downloads

1.zip | 2
2.zip | 10
3.zip | 50

how would i, using mysql/php, count the the data in the downloads field and return the result of the equation

in this example the script should return - 62

thanks Comms

[AstroTeg]

Two approaches depending on how you're playing with the data...

First one is via SQL:

SELECT SUM(Downloads) AS dltotal FROM mytable GROUP BY Downloads

You can use SUM() to add up all the values. Trick is you will only get 1 row which contains the answer.

The 2nd trick is if you wish to pull in the name of the download and the number of downloads, you could tell PHP to keep track of the total number of downloads. In your PHP loop you have to retrieve all the records, you could put in the loop something like: $totaldownload += [variable with this record's number of downloads]

Then $totaldownload gets updated for every record you loop through.

[tuf-web_co_uk]

thanks!

i knew there was a way because i had used it before, but couldnt find the right code for it, but i shall use the SUM() function because as you sed it only returns one row, which is what i want

😉