[SOLVED] adding with php

[yjim]

how can i count the sum of downloads that is stored in several mysql rows

 

i tried this:

 

	$query = mysql_query("SELECT downloads FROM items WHERE downloads != 0");
	while ($row = mysql_fetch_array($query)) {
		echo $row['downloads'];
	}

but it doesnt add all the rows together.

[wildteen88]

Your code does not do any form of counting. All you're telling it to do is to select all rows from the database where downloads is not equal to 0. Your then looping through the results.

 

What where you expecting?

[smerny]

SUM(downloads) as total

[yjim]

Your code does not do any form of counting. All you're telling it to do is to select all rows from the database where downloads is not equal to 0. Your then looping through the results.

 

What where you expecting?

 

idk its supposed to count the total number of downloads from all the items but its not working. can u fix it?

[yjim]

SUM(downloads) as total

 

says call to undefined function

[wildteen88]

SUM(downloads) as total

 

says call to undefined function

You're supposed to use it within your query. SUM is a MySQL function

[yjim]

ah that did it, thx.