Thread: fetchAll order_by and ASC/DESC?
View Single Post
  #3 (permalink)  
Old 10-18-2007, 08:10 PM
celavi's Avatar
celavi celavi is offline
Junior Member
  
Join Date: Jun 2007
Posts: 1
Default Zend_Db_Select
Try the Zend_Db_Select object!

/** $db Zend_Db_Adapter */

$select = $db->select()
->from('table', array('column1', 'column2'))
->order(array('column1 DESC', 'column2 ASC'));
$results = $db->fetchAll($select);

Regards,
AlesL
Reply With Quote