svn: /pear/pearweb/trunk/include/ pear-database-channel.php

clockwerx                                Sat, 09 Apr 2011 13:44:44 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=310088

Log:
Fetch assoc, not ordered

Changed paths:
    U   pear/pearweb/trunk/include/pear-database-channel.php

Modified: pear/pearweb/trunk/include/pear-database-channel.php
===================================================================
--- pear/pearweb/trunk/include/pear-database-channel.php	2011-04-09 13:40:24 UTC (rev 310087)
+++ pear/pearweb/trunk/include/pear-database-channel.php	2011-04-09 13:44:44 UTC (rev 310088)
@@ -74,8 +74,8 @@
     static function listAll()
     {
         global $dbh;
-        $query = 'SELECT name FROM channels';
-        return $dbh->getAll($query, null, DB_FETCHMODE_ORDERED);
+        $query = 'SELECT name, project_label, project_link, contact_name, contact_email FROM channels';
+        return $dbh->getAll($query, null, DB_FETCHMODE_ASSOC);
     }

     /**
@@ -85,8 +85,8 @@
     static function listActive()
     {
         global $dbh;
-        $query = 'SELECT name FROM channels WHERE is_active = 1';
-        return $dbh->getAll($query, null, DB_FETCHMODE_ORDERED);
+        $query = 'SELECT name, project_label, project_link, contact_name, contact_email FROM channels WHERE is_active = 1';
+        return $dbh->getAll($query, null, DB_FETCHMODE_ASSOC);
     }


@@ -97,7 +97,7 @@
     static function listInactive()
     {
         global $dbh;
-        $query = 'SELECT name FROM channels WHERE is_active = 0';
-        return $dbh->getAll($query, null, DB_FETCHMODE_ORDERED);
+        $query = 'SELECT name, project_label, project_link, contact_name, contact_email FROM channels WHERE is_active = 0';
+        return $dbh->getAll($query, null, DB_FETCHMODE_ASSOC);
     }
 }