From 18efe997591ff832cd25c7008d4fab87c694242b Mon Sep 17 00:00:00 2001 From: Andreas Unterkircher Date: Sat, 7 Jun 2008 17:18:49 +0200 Subject: [PATCH] issue124, fix sort-order problem when sort by rating Signed-off-by: Andreas Unterkircher --- phpfspot.class.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/phpfspot.class.php b/phpfspot.class.php index 2b5e180..107ce4c 100644 --- a/phpfspot.class.php +++ b/phpfspot.class.php @@ -2722,10 +2722,10 @@ class PHPFSPOT { return " ORDER BY t.name DESC ,p.time ASC"; break; case 'rate_asc': - return " ORDER BY t.name ASC, p.rating ASC"; + return " ORDER BY p.rating ASC, t.name ASC"; break; case 'rate_desc': - return " ORDER BY t.name DESC, p.rating DESC"; + return " ORDER BY p.rating DESC, t.name DESC"; break; } -- 2.25.1