[Resolved] How to total & sort into categories

deregular

Hi all,

Newbie question here. I know its gotta be simple, but my brain is not getting around it yet.

Heres my table

ID | NAME TOTAL

1 | John | 53.78
2 | Shawn | 98.67
3 | Matt | 34.99
4 | John | 23.50
5 | Matt | 15.90

I am totally stuck as to how to query a table like this
and display each employee only once with their total earned.

Am i going to have to do two queries to the database or can this be done by grouping rows somehow?

Any help is much appreciated. cheers.

trex005

SELECT
NAME,
SUM(TOTAL) as TOTAL
FROM
table_name
GROUP BY
NAME

tsinka

Hi,

do something like (using for example MySQL functions):

  $con = mysql_connect("host","user","pass") or die("Connection error: ".mysql_error());
  mysql_select_db("db",$con) or die("Selection error: ".mysql_error());
  $sql = "SELECT NAME, SUM(TOTAL) AS total FROM thetable GROUP BY NAME";
  $res = mysql_query($sql,$con) or die("SQL error: ".mysql_error());

  while ($row = mysql_fetch_assoc($res)) {
    echo "Name: ".$row['NAME']." - Total: ".$row['total']."<br>\n";
  }

Thomas

deregular

thanks for the help so far, im getting there.

theres something wrong there though, the totals arent showing at all.

here is the code i am using..

$sql = "SELECT m_employee, SUM(m_total) AS TOTAL FROM earnings GROUP BY m_employee"; 
  	$res = mysql_query($sql) or die("SQL error: ".mysql_error()); 

while ($row = mysql_fetch_assoc($res)) { 
	echo "Name: {$row['m_employee']}  - Total: {$row['m_total']}<br>\n"; 
}

Here is the result

Name: John - Total: 
Name: Shawn - Total: 
Name: Matt - Total:

Sure Hope you guys can help, im stumped and never used the TOTAL or GROUP sql functions before.

deregular

Forget it i know what i did wrong...

Instead of

$sql = "SELECT m_employee, SUM(m_total) AS TOTAL FROM earnings GROUP BY m_employee";

it should have been

$sql = "SELECT m_employee, SUM(m_total) AS m_total FROM earnings GROUP BY m_employee";

thanks for your help guys. 😉

trex005

I'm so proud of you for marking resolved!