Q:

How to set '0' value to the end while sorting

I trying to sort My table value in "asc" order, well i have used following code to get result, but Result i get is in form of 0,01,02.. i want it to be as 01,02..
how do i do it..i had used some function for joining tables..
$where_array = array('publications.status =' => 1);
$orderby = $this->db->order_by("uv_nirf", "ASC");
$data['universities'] = $this->common_model->pub_seo_join('vm_universities','','uv_id',$where_array,$orderby);

A:

Only need to change ur order_by to following code..  
$where_array = array('publications.status =' => 1);
$orderby = $this->db->order_by("uv_nirf = 0,uv_nirf");
$data['universities'] = $this->common_model->pub_seo_join('vm_universities','','uv_id',$where_array,$orderby);

check if this will work..

