我正在执行两个存储过程但只有第一部分正在执行而部分部分返回null

Question

$link = mysqli_connect('localhost','root','','icoachswim_sp');
if($result1 = mysqli_query($link,"call sp_SetupGroupsManageEventsGroups(".$uid.")")) {
    while($row1 = mysqli_fetch_array($result1)) {
        echo '<pre>';
        print_r($row1);
        echo '</pre>';
        array_push($array_gids,$row1['id']);
    }
 }                    

 if($result = mysqli_query($link,"call sp_SetupGroupsManageEvents('".$groupID."',".$uid.")")) {
     while($row = mysqli_fetch_array($result)) {
         echo '<pre>';
         print_r($row);
         echo '</pre>';
         array_push($arr_group_events,$row);
     }
}

Answer 1

mysqli_query will not execute multiple queries. Check out this answer: Multiple queries within a single mysqli_result