Jump to content

Archived

This topic is now archived and is closed to further replies.

onlyican

Sum of values in php

Recommended Posts

Hey
My brain is dead today, I had too much sleep last night, I hit 5 hours. (This is a lot to me)

Anyway

I have a Mysql Table
In that table I have a field called amount, which is a double
and a field called aff, which is a number not unique, but refers to the id_num of the affiliates

Anyway

I am running a query to find out who is owed money, and how much

This is wha I have so far

$query2 = "SELECT * FROM sales WHERE paid = 'n' GROUP BY aff";

The problem is this only gives me one value from the amount, it is not adding them up

I can run another query
$total_amount = "SELECT SUM(amount) FROM sales WHERE paid = 'n' AND aff = '".$row2["aff"]."'";

But is there a better way to do all this

I am thinking off the amount of queries that might run on one page

Share this post


Link to post
Share on other sites
try
[code]$total_amount = "SELECT SUM(amount) FROM sales WHERE paid = 'n' GROUP BY aff";[/code]

Share this post


Link to post
Share on other sites
mm, simular to what I posted and did not want to use

Anyway I am using it, it works out best for the rest of the code
thanx

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.