result() ? or row()? or what?!

[eluser]InsiteFX[/eluser]

Code:

function get_friend_requests()
    {
        $data - array();

        $this->db->where('reciever_id', $this->session->userdata('id'));
        $this->db->where('pending', 1);
        $query = $this->db->get('friends');
        
        if($query->num_rows() > 0)
        {
            $data = $query->row_array();
        }

        $query->free_result();
        return $data;
    }

Here is another way:

Code:

$data = array();

     if ($query->num_rows() > 0)
     {
         foreach ($query->result_array() as $row)
         {
             $data[] = $row;
         }
     }

    $query->free_result();
    return $data;

InsiteFX