From 86d02b0c7a4a64792b6edfbed5a1fbe270444907 Mon Sep 17 00:00:00 2001 From: pb1dft Date: Wed, 25 Oct 2006 21:34:14 +0000 Subject: Fixed Stats for Mysql version 4 Left it like this for vollmer to test --- lib/class/stats.class.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'lib') diff --git a/lib/class/stats.class.php b/lib/class/stats.class.php index ba97badf..745232b9 100644 --- a/lib/class/stats.class.php +++ b/lib/class/stats.class.php @@ -77,7 +77,7 @@ class Stats { /* Select Top objects counting by # of rows */ $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" . " WHERE object_type='$type' AND date >= '$date'" . - " GROUP BY object_id ORDER BY COUNT(object_id) DESC LIMIT $count"; + " GROUP BY object_id ORDER BY `count` DESC LIMIT $count"; $db_results = mysql_query($sql, dbh()); $results = array(); @@ -112,7 +112,7 @@ class Stats { /* Select Objects based on user */ $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" . " WHERE object_type='$type' AND date >= '$date' AND user = '$user'" . - " GROUP BY object_id ORDER BY COUNT(object_id) DESC LIMIT $count"; + " GROUP BY object_id ORDER BY `count` DESC LIMIT $count"; $db_results = mysql_query($sql, dbh()); $results = array(); -- cgit