[Resolved] Output SELECT SUM()

[twcmad]

Hi I am trying to display the count of the following mysql statment and am having issues.

This is my query statment which is not retruning an error.

$con = "SELECT SUM(Count),Page FROM counter GROUP BY Page ORDER BY Date DESC";
$con_results = mysql_query($con,$dbh)

This is my display statment

while($row = mysql_fetch_array($con_results))
 {
   $bgcolor="#F7F7F7"; if (is_int($i/2)) { $bgcolor="#F0F0F0";}

  print("<tr bgcolor=$bgcolor><td>$row[Page]</td><td align=\"center\">$row[SUM]</td></tr>");
  $i ++;
 }

This is displaying the $row[Page] fine but I am not sure how to display the Sum or Count for page.

What Have I done wrong ???

Thanks

TWCMAD

[bubblenut]

SELECT SUM(Count) as SUM,Page FROM counter GROUP BY Page ORDER BY Date DESC

HTH
Bubble

[Lars_Berg]

Using order by on a column not in the result set when using a group by clause does not make sense. It shouldn't even be allowed. Typical mysql sloppiness.

[twcmad]

Thanks for the advice all,

And thanks to Lars Berg for advising me of that.