Jump to content


Photo

Sum of values in php


  • Please log in to reply
2 replies to this topic

#1 onlyican

onlyican
  • Members
  • PipPipPip
  • Advanced Member
  • 921 posts
  • LocationHants - UK

Posted 09 August 2006 - 01:42 PM

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


Tell me the problem, I will try tell you the solution

#2 sasa

sasa
  • Staff Alumni
  • Advanced Member
  • 2,804 posts
  • LocationHrvatska

Posted 09 August 2006 - 02:46 PM

try
$total_amount = "SELECT SUM(amount) FROM sales WHERE paid = 'n' GROUP BY aff";


#3 onlyican

onlyican
  • Members
  • PipPipPip
  • Advanced Member
  • 921 posts
  • LocationHants - UK

Posted 09 August 2006 - 03:08 PM

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
Tell me the problem, I will try tell you the solution




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users