Limit 5 messing up items returned.

[eluser]Mixon851[/eluser]
I can't get my code to return the dates with the LIMIT 5 in there. I had it in active records style before and that didn't help. I think it has to have something with 4 rows coming back. It works fine with the LIMIT 5 in phpMyAdmin sql browser, just not with CI.

Any suggestions?

Code:

//Model
        function get_events($site_id){
        $sql = 'SELECT * FROM tbl_event WHERE siteID = '.$site_id.' and publish = 1 ORDER BY eventStartDate ASC LIMIT 5';
        $query = $this->db->query($sql);
        foreach($query->result() as $row){
            $data[] = array(
            'event_id' => $row->eventID,
            'biz_id' => $row->bizID,
            'event_title' => $row->eventTitle,
            'event_type_id' => $row->eventTypeID,
            'event_start_date' => $row->eventStartDate,
            'event_start_hour' => $row->eventStartHr,
            'event_start_min' => $row->eventStartMin,
            'event_start_mar' => $row->eventStartMar,
            'event_end_date' => $row->eventEndDate,
            'event_end_hour' => $row->eventEndHr,
            'event_end_min' => $row->eventEndMin,
            'event_end_mar' => $row->eventEndMar,
            'event_desc' => $row->eventDesc,
            'create_date' => $row->createDate,
            );
        }
        return $data;
    }
    
//Controller just passes the return of get_events through $data['events'] to view


//View
    $datestring = "%Y-%m-%d";
    $time = time();
    $date = mdate($datestring, $time);
        foreach($events as $event){
            $date_string = "%F %j%S, %Y";
            if($event['event_end_date'] >= $date){
                echo '<span id="event_date">'.mdate($date_string, strtotime($event['event_start_date'])).'</span><br />';
            }
    }

[eluser]Mutsop[/eluser]
Have you tried with the active records?

Code:

//model

$this->db->where('siteID',$site_id);
$this->db->order_by('eventStartDate','asc');
return $this->db->get($this->tbl_event, 5);

//controller

$data['events'] = $this->eventsname_model->get_events($site_id)->result();

//view
<?php foreach($events as $event):?>
   <span>&lt;?php echo mdate($date_string, strtotime($event->event_start_date);?&gt;</span>
&lt;?php endforeach;?&gt;

[eluser]Mixon851[/eluser]
Yeah, I had tried the active record way.