issue124, fix sort-order problem when sort by rating
authorAndreas Unterkircher <unki@netshadow.at>
Sat, 7 Jun 2008 15:18:49 +0000 (17:18 +0200)
committerAndreas Unterkircher <unki@netshadow.at>
Sat, 7 Jun 2008 15:25:18 +0000 (17:25 +0200)
Signed-off-by: Andreas Unterkircher <unki@netshadow.at>
phpfspot.class.php

index 2b5e180..107ce4c 100644 (file)
@@ -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;
       }