From c9d3c3d94f18d97cf6a3657b84465401a5a08eb7 Mon Sep 17 00:00:00 2001 From: Artem Daniliants Date: Tue, 30 Mar 2010 22:26:58 +0300 Subject: [PATCH] Fixed result ordering bug --- Server/application/models/result.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Server/application/models/result.php b/Server/application/models/result.php index b7fd283..a70d222 100644 --- a/Server/application/models/result.php +++ b/Server/application/models/result.php @@ -23,7 +23,7 @@ class Result_Model extends Model { * @return object|bool Returns object containing results if everything is ok and false otherwise */ public function get_results($category, $limit=10){ - $results = $this->db->query("SELECT u.username as username, c.unit as unit, r.value as value, r.result_date as result_date, c.slug as slug FROM users u, results r, categories c WHERE r.user_id=u.id AND c.slug = ? AND r.cat_id=c.id ORDER BY value DESC LIMIT ".(int)$limit, $category); + $results = $this->db->query("SELECT u.username as username, c.unit as unit, r.value as value, r.result_date as result_date, c.slug as slug FROM users u, results r, categories c WHERE r.user_id=u.id AND c.slug = ? AND r.cat_id=c.id ORDER BY r.value ASC LIMIT ".(int)$limit, $category); if ($results->count()>0) return $results; else -- 1.7.9.5