alphabetic tag search order

git-svn-id: file:///var/lib/svn/phpfspot/trunk@115 fa6a889d-dae6-447d-9e79-4ba9a3039384

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 9c426a30ce20f678d9daa95eb2c141305d491faa..eb8a8e66b32b18cd60062450d9711fe836c6cbdb 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -154,8 +154,10 @@ class PHPFSPOT {
       $result = $this->db->db_query("
          SELECT tag_id as id, count(tag_id) as quantity
          FROM photo_tags
       $result = $this->db->db_query("
          SELECT tag_id as id, count(tag_id) as quantity
          FROM photo_tags

+         INNER JOIN tags t
+            ON t.id = tag_id

          GROUP BY tag_id
          GROUP BY tag_id

-         ORDER BY tag_id ASC
+         ORDER BY t.name ASC

       ");
 
       $tags = Array();
       ");
 
       $tags = Array();