mySQL sum traffic from two tables.

bartzz

Hi, i've been wondering how to solve this:

I want to count traffic in my download page i have tables (bytes and downloads)

Does any one have idea how to write code which will do something like:

SIZE TOTAL_DOWNLOADS = XXX
XXX + SIZE TOTAL_DOWNLOADS = XXX
XXX + SIZE TOTAL_DOWNLOADS = XXX
XXX + SIZE TOTAL_DOWNLOADS = XXX

$total = mysql_query("SELECT * FROM skins");
while ($b = mysql_fetch_array($total)){
$size = $b['size'] * $b['downloads'];
}

i was trying array_sum but it didn't work thanks in adv..

nevvermind

You can select just the columns you need.

$total = mysql_query("SELECT `size`, `downloads` FROM skins");

while ($b = mysql_fetch_array($total)){
  // add the result to an array
  $size[] = $b['size'] * $b['downloads'];
}

echo array_sum($size);

bartzz

Thanks works great and fast !

bradgrafelman

Do you actually need any of the individual pieces of data (e.g. rows)? If not, why not just let MySQL do the work:

SELECT SUM(size * downloads) FROM skins