issue124, fix sort-order problem when sort by rating

Signed-off-by: Andreas Unterkircher <unki@netshadow.at>

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 2b5e180d4a985fa077c61e1bbefe759cee01523a..107ce4ce034f9cae517211923a4480a23e91716b 100644 (file)
--- 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;
       }