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

[Daniel O'Connor]

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);
}
}