script exits when freeing result set

[cupboy]

Why does my script exit prematurely as soon as it frees the result set? This is undesired.

     for ($loop=0; $loop<count($sqld); $loop++) {

    try {
      if ($first_delete < 1)
        echo "$sqld[$loop] \n";
      $result = $mysqli->query($sqld[$loop]); 
      printf("Affected rows (DELETE): %d\n", $mysqli->affected_rows);                
      // free result set 
      $result->close(); // for some odd reason the script exits after this!

[Bonesnap]

Can you provide some more information? What do you mean by "exit"? Do you get a PHP error? A blank page? Does your script time out?

[NogDog]

My first thought is that something else tries to use that result set and throws a fatal error since it's not there any more?

[dalecosp]

Since you don't show the rest, how could we know?

Maybe you forgot the closing brace for the try statement :rolleyes: 😃