summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAndreas Unterkircher <unki@netshadow.at>2007-06-20 04:31:48 +0000
committerAndreas Unterkircher <unki@netshadow.at>2007-06-20 04:31:48 +0000
commit8bd24a3538f0825a4c6a4e76a05a9f6e0df64464 (patch)
treec525964ed31f531bd2a3a5410f48afcbf45cee84
parentc6745c143300a59acc48cec937b77ab071a5a693 (diff)
alphabetic tag search order
git-svn-id: file:///var/lib/svn/phpfspot/trunk@115 fa6a889d-dae6-447d-9e79-4ba9a3039384
-rw-r--r--phpfspot.class.php4
1 files changed, 3 insertions, 1 deletions
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();