calculating and adding column values in mysql php

Question

I have the following table

AffID    l      Commision
-------------------------
MW001              5

MW004              10

MW001              25

MW001              5

MW004              5

I want to submit a query that counts the amount in a column. So for example the output i am looking for is :

MW001 - 35

The query i am using now does not working correctly, it counts the actual amount of records.

$sql = "SELECT COUNT(*) as c FROM toutcome WHERE affID = '" . $_SESSION['affID'] . "'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo  $row['c'] ;

perhaps the name of the function should clue you in: COUNT() is doing exactly what you're getting. Perhaps you should use SUM() instead. — Marc B
– Marc B, Commented Aug 15, 2014 at 13:53

Rahul Tripathi · Accepted Answer · 2014-08-15 13:54:15Z

1

Try this query

select sum(Commission) from toutcome where affID = 'MW001'

So your query should be

$sql = "SELECT SUM(Commission) as c FROM toutcome WHERE affID = '" . $_SESSION['affID'] . "'";

answered Aug 15, 2014 at 13:54

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Ruddell · Accepted Answer · 2014-08-15 13:55:36Z

0

to see all of the different commissions you can sum and group by

SELECT SUM(commission) FROM toutcome GROUP BY affID

so see a specific one just do this

SELECT SUM(commission) FROM toutcome WHERE affID = whicheveroneyouwant

answered Aug 15, 2014 at 13:55

John Ruddell

25.9k7 gold badges60 silver badges88 bronze badges

3 Comments

user3485335 Over a year ago

$sql = "SELECT SUM(AffCommission) FROM toutcome WHERE affID = '" . $_SESSION['affID'] . "' and DATE_SUB(NOW(), INTERVAL 1 WEEK) "; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo $row['AffCommission'] ;

John Ruddell Over a year ago

@user3485335 do you have a date created in your table?

John Ruddell Over a year ago

@user3485335 sure thing! don't forget to mark an answer as accepted to keep the community as is :)

Collectives™ on Stack Overflow

calculating and adding column values in mysql php

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related