two order by clause in sql query

[eluser]core-coder[/eluser]
[quote author="Armchair Samurai" date="1267189924"]Assuming you mean CI Active Record, just call order_by() two times, once for each clause, just pass your own string to order_by().

Code:

$this->db->order_by('categories_order', 'asc');
$this->db->order_by('categories_name', 'asc');

$query = $this->db->get('categories');

// OR

$this->db->order_by('categories_order ASC, categories_name ASC');

$query = $this->db->get('categories');

[/quote]

Thanks I got it by $this->db->order_by('categories_order ASC, categories_name ASC');