use Zend\Db\Adapter\Adapter,
Zend\Db\ResultSet\ResultSet,
Zend\Db\Sql\Select;
$select = new Select('user');
$select->columns(array('user_id', 'register_time'));
$select->order(array('register_time DESC'));
//$select->order(array('register_time ASC')); //Or Ascending
$statment = $dbAdapter->createStatement();
$sql->prepareStatement($dbAdapter, $statment);
$resultSet = new ResultSet();
$resultSet->setDataSource($statment->execute());
foreach ( $resultSet as $value ) {
echo "User: {$value->register_time}";
}
It always returns in the same order,
Am I doing something wrong?
Thanks!
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/ZF2-Db-Sql-Select-order-method-isn-t-working-yet-tp4604941.html
Sent from the Zend Framework mailing list archive at Nabble.com.
--
List: [email protected]
Info: http://framework.zend.com/archives
Unsubscribe: [email protected]
