# Grouping & Adding my query results together

**URL:** <https://forum.kirupa.com/t/grouping-adding-my-query-results-together/327876>\
**Category:** programming\
**Created:** [April 3, 2012, 5:43am UTC](https://forum.kirupa.com/t/grouping-adding-my-query-results-together/327876 "2012-04-03T05:43:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonhardwick](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jasonhardwick](https://forum.kirupa.com/u/jasonhardwick)\
**Post date:** [April 3, 2012, 5:43am UTC](https://forum.kirupa.com/t/grouping-adding-my-query-results-together/327876/1 "2012-04-03T05:43:16Z")

</div>

Once I query my MYSQL database I need to take the results and add the records with the same salesperson. Right now here is my PHP:

```php
<?php$query="(SELECT `sales_person_1` AS sales_person, SUM(`system_size`)*`commission1` AS commission FROM `pv_jobs` WHERE x_sales_mgr ='2' GROUP BY sales_person)UNION(SELECT `sales_person_2` AS sales_person, SUM(`system_size`)*`commission2` AS commission FROM `pv_jobs` WHERE x_sales_mgr ='2' GROUP BY sales_person)UNION(SELECT `sales_person_3` AS sales_person, SUM(`system_size`)*`commission3` AS commission FROM `pv_jobs` WHERE x_sales_mgr ='2' GROUP BY sales_person)UNION(SELECT `sales_person_4` AS sales_person, SUM(`system_size`)*`commission4` AS commission FROM `pv_jobs` WHERE x_sales_mgr ='2' GROUP BY sales_person) ORDER BY commission DESC ";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){ echo $row['sales_person']. " Has Sold " .$row['commission']. " Watts!"; echo "<br />";}?>

```

And here is the results:

> 

Sales Person 1 Has Sold 1000 Watts!  
Sales Person 3 Has Sold 1000 Watts!  
Sales Person 3 Has Sold 1000 Watts!  
Sales Person 2 Has Sold 1000 Watts!  
Sales Person 1 Has Sold 1000 Watts!  
Sales Person 4 Has Sold 1000 Watts!  
Sales Person 6 Has Sold 1000 Watts!  
Sales Person 2 Has Sold 1000 Watts!  
Sales Person 3 Has Sold 1000 Watts!  
Sales Person 1 Has Sold 1000 Watts!  
Sales Person 1 Has Sold 1000 Watts!  
Sales Person 6 Has Sold 1000 Watts!  
Sales Person 6 Has Sold 1000 Watts!  
Sales Person 2 Has Sold 1000 Watts!  
Sales Person 3 Has Sold 1000 Watts!  
Sales Person 1 Has Sold 1000 Watts

I need my code to find the similar salesperson name and add the commission together to give me a total like:

> 

Sales Person 1 Has Sold 100000 Watts!  
Sales Person 2 Has Sold 100000 Watts!  
Sales Person 3 Has Sold 100000 Watts!  
Sales Person 4 Has Sold 100000 Watts!  
Sales Person 5 Has Sold 100000 Watts!  
Sales Person 6 Has Sold 100000 Watts!

Can anyone help?

Thanks