php - Multiple queries in stored procedure not working in codeigniter

Question

Need to fetch all rows from 3 tables where current status =1

$query =  $this->db->query("CALL GetALLDetails('1')");
$result = $query->result_array();
print_r($result);

Stored Procedure:-

BEGIN
 select * from table1 where current_status = status;
 select * from table2 where current_status = status;
 select * from table3 where current_status = status;
END

Am getting result of first query statement only.

Answer 1

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER SQL QUERY...');
$this->db->query('AND YET ANOTHER SQL  QUERY...');
$this->db->trans_complete(); 

Note:- For more about transactions

• transactions