issue85, fixed order-by-photo name

[phpfspot.git] / phpfspot.class.php

diff --git a/phpfspot.class.php b/phpfspot.class.php
index b3ad278458a350089ae2ea5ac6e09107e1d9be0b..6d3ddddc681e83dc4e7c3186c54d9951210c48a9 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -1955,7 +1955,7 @@ class PHPFSPOT {
                return " ORDER BY p.name ASC";
             }
             else {
                return " ORDER BY p.name ASC";
             }
             else {

-               return " ORDER BY p.uri ASC";
+               return " ORDER BY basename(p.uri) ASC";

             }
             break;
          case 'name_desc':
             }
             break;
          case 'name_desc':


@@ -1963,7 +1963,7 @@ class PHPFSPOT {
                return " ORDER BY p.name DESC";
             }
             else {
                return " ORDER BY p.name DESC";
             }
             else {

-               return " ORDER BY p.uri DESC";
+               return " ORDER BY basename(p.uri) DESC";

             }
             break;
       }
             }
             break;
       }