http://framework.zend.com/manual/en/zend.db.select.html#zend.db.select.building.order
"In Zend_Db_Select, you can use the order() method to specify a column
or an array of columns by which to sort. Each element of the array is a
string naming a column. Optionally with the ASC DESC keyword following
it, separated by a space."
So just concat a "DESC" after the $order column:
public function sortGadget($order)
{
$db = Zend_Db_Table::getDefaultAdapter();
$selgadget = new Zend_Db_Select($db);
$selgadget->from('gadget')
->order($order . ' DESC');
return $selgadget;
}
El mar, 06-10-2009 a las 21:06 -0700, attractive eyes escribió:
> hi all,
> I am using the function given below to sort data and the direction
> of sorting is ascending. now I want to sort data in descending order, but I
> am not getting idea about it and it is mandatory for me to use the object of
> "Zend_Db_Select()" for sorting. please help me for sorting in desecding.
>
>
> public function sortGadget($order)
> {
>
> $db = Zend_Db_Table::getDefaultAdapter();
> $selgadget = new Zend_Db_Select($db);
> $selgadget->from('gadget')
> ->order($order);
>
>
> return $selgadget;
> }
>
> Regards
> Rizwan
