Changeset 1729 for trunk/gregarius/admin/folders.php

Timestamp:

06/08/07 21:30:23 (18 months ago)

Author:

cfriesen

Message:

show all folders, even ones with 0 feeds in them.

Files:

• trunk/gregarius/admin/folders.php (modified) (1 diff)

trunk/gregarius/admin/folders.php

@@ -53 +53 @@
     ."</tr>\n";
 
-
-    $sql =
-        sprintf("select f.id, f.name, count(*) from %s f, %s c where c.parent=f.id group by id",
-                getTable('folders'), getTable('channels')
-               );
+        $sql = "SELECT f.id, f.name, count(c.id) AS cnt "
+                 . "FROM " . getTable('folders') . " f "
+                 . "LEFT JOIN " . getTable('channels') . " c "
+                 . "  ON c.parent=f.id "
+                 . "GROUP BY f.id, f.name ";
 
     if (getConfig('rss.config.absoluteordering')) {
-        $sql .=" order by f.position asc";
+        $sql .=" ORDER BY f.position ASC";
     } else {
-        $sql .=" order by f.name asc";
-    }
-
-
+        $sql .=" ORDER BY f.name ASC";
+    }
 
     $res = rss_query($sql);