Re: Re: Liveuser_Admin: listing users alphabetically

From:	Jeroen Houben	Date:	Tue, 06 Sep 2005 12:57:58 +0000
Subject:	Re: Re: Liveuser_Admin: listing users alphabetically
References:	1 2 3 4 5	Groups:	php.pear.general
Request:	Send a blank email to pear-general+get-20810@lists.php.net to get a copy of this message

Jeroen Houben wrote:

Lukas Smith wrote:
Jeroen Houben wrote:
Lukas Smith wrote:
Jeroen Houben wrote:
Hi, I'm trying to list my users in alphabetical order, but it throws me an error (see below). He're my code:
       $params = array();
       $params['orders'] = array('auth_user_id');
this needs to be: $params['orders'] = array('auth_user_id' => $direction); where $direction is either 'ASC' or 'DESC'.
Hmm. The following doesn't throw an error, but it doesn't work either. Changing DESC to ASC makes no difference.
       $params = array();
       $params['orders'] = array('auth_user_id' => 'DESC');
       $users = $lu_admin->perm->getUsers($params);
uhm .. could you do the following for me and provide me the output var_dump($lu_admin->perm->_storage->dbc->last_query);
string(153) "SELECT perm_user_id AS perm_user_id, auth_user_id AS auth_user_id, auth_container_name AS auth_container_name, perm_type AS perm_type FROM lu_perm_users" Seems like it's totally skipping the order by..

Some more investigation shows that findTables(&$fields, &$filters, &$orders, $selectable_tables) is somehow resetting $orders. Jeroen