Re: [fw-general] Zend_Db_Select Order By

[Tom Graham]

Hi,

Try something like: $select->where('b.status = ?', 'new')- 
>order('b.status ASC');

On 8 Oct 2008, at 13:22, Elvin Şiriyev wrote:

hi,

i can't use "order by" like that:

$select->order("b.status = 'new'");

Error Message : Fatal error: Uncaught exception  
'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare  
error: Unknown column 'b.status = 'new'' in 'order clause'' in ...

Thanks for helps,

--
Elvin Şiriyev