From 8bd24a3538f0825a4c6a4e76a05a9f6e0df64464 Mon Sep 17 00:00:00 2001
From: Andreas Unterkircher <unki@netshadow.at>
Date: Wed, 20 Jun 2007 04:31:48 +0000
Subject: alphabetic tag search order

git-svn-id: file:///var/lib/svn/phpfspot/trunk@115 fa6a889d-dae6-447d-9e79-4ba9a3039384
---
 phpfspot.class.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'phpfspot.class.php')

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 9c426a3..eb8a8e6 100644
--- 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
+         INNER JOIN tags t
+            ON t.id = tag_id
          GROUP BY tag_id
-         ORDER BY tag_id ASC
+         ORDER BY t.name ASC
       ");
 
       $tags = Array();
-- 
cgit v1.2.3-18-g5258