execution of stored procedure in mysql i have two stored procedure first is without parameter and second is with two parameter. both are working fine in mysql as shown in image
i used the follwoing line to fetch the data in codeignitor but does not work
$sn=$this->session->userdata('running_session_id'); $sid=$row['student_id'];
$studnet_name = $this->db->query("call fetch_student()"); $row1 = $studnet_name->row_array();
$studnet_fee = $this->db->query("call fetch_student_fee_structure($sn,$sid)"); $row2 = $studnet_fee->row_array();
because these procedure have very complex query so i need to fetch data in codeignitor