Logic in model?

[eluser]behnampmdg3[/eluser]
Hey, how can I use theis query so it works even if there is no limit assinged ($limit=NULL). Cause if I do not assign limit at the moment it puts zero as limit!:

Code:

public function list_celebrities($limit=NULL).
{
  $this->db->select('sincity_events_celebrities.id AS EID, sincity_celebrities.id, sincity_celebrities.name, sincity_celebrities.facebook, sincity_celebrities.photo, sincity_celebrities.twitter, sincity_celebrities.website, sincity_celebrities.type');
  $this->db->from('sincity_celebrities');
  $this->db->join('sincity_events_celebrities', 'sincity_events_celebrities.celebrity_id = sincity_celebrities.id', 'LEFT OUTER');
  $this->db->where('type !=', 'DJ');
  $this->db->group_by("sincity_celebrities.id");
  $this->db->order_by("sincity_events_celebrities.id DESC");
  $this->db->limit($limit);
  
  $query = $this->db->get();
  foreach($query->result() as $row)
   {
     $this->result[]=array('id'=>$row->id,'name'=>$row->name, 'facebook'=>$row->facebook, 'photo'=>$row->photo, 'twitter'=>$row->twitter, 'website'=>$row->website, 'type'=>$row->type, 'EID'=>$row->EID);
   }
   return $query;
}

Thanks

[eluser]Harold Villacorte[/eluser]
$limit = 1 or whatever default limit you want to give it.

[eluser]Aken[/eluser]
Check if it's null first.