CodeIgniter Forums

Full Version: Two procedures continuesly not working
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
If I'm executing only 1 procedure in the model - all works fine, but 2 returns nothing. If I use simple query(not procedure) in first part, all is working fine

For example:

Code:
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
   class Newroom_model extends CI_Model {

       function __construct()
       {
           parent::__construct();
       }

       function get()
       {
           $data=array();

           //First
           $query=$this->db->query("call GetHomeTypes()");
           $res = $query->result_array();
           for($i=0;$i<count($res);$i++)
           {
               $data['home_Types'][$i]['Type_ID']=$res[$i]['TypeID'];
               $data['home_Types'][$i]['Type_Name']=$res[$i]['TypeName'];
           }
           //Second
           $query2=$this->db->query("call GetRoomTypes()");
           $res1 = $query2->result_array();
           for($i=0;$i<count($res1);$i++)
           {
               $data['room_Types'][$i]['Type_ID']=$res1[$i]['TypeID'];
               $data['room_Types'][$i]['Type_Name']=$res1[$i]['TypeName'];
           }

           // print_r($data);
           return $data;
       }
   }
?>
Try adding this:

PHP Code:
$query->free_result();

//Second 


This usually happens because the first query has not finished running.