[SOLVED] Multiple SUMs in 1 query?

[l3asturd]

[code]The following code works great:

[code]<?php
// connect and select the database
$conn = mysql_connect($host, $user, $password) or die(mysql_error());
$db = mysql_select_db($dbName, $conn) or die(mysql_error());
// Pull the results from the table
$select_result = mysql_query("SELECT Name, SUM(Score) as TotalScore FROM TLB GROUP BY Name ORDER BY TotalScore", $conn);
while ($list = mysql_fetch_array($select_result)):
if ($list['Name'] != ""):
$content .= "<font color=silver>Name</font> <font color=red><b>".$list['Name']."</b></font>";
$content .= "<font color=silver> Total Score</font><font color=red><b> ".$list['TotalScore']."</b></font><br>";
endif;
endwhile;

echo $content;
?>

 

however, when I the change the query line to this it doesn't work:

 

<?php
$select_result = mysql_query("SELECT Name, SUM(Score) as TotalScore, SUM(Purse) as TotalPurse, SUM(Aces) as TotalAces,  FROM TLB GROUP BY Name ORDER BY TotalScore", $conn);
?>

 

Am I trying the impossible? Is there too much going on in 1 query?

[/code][/code]

[l3asturd]

oh jeez I put one too many commas, nevermind. It works fine.