Menu
Community /Pin to ProfileBookmark
@NogDogOct 03.2013 — #I've never used mysqli_multi_query() (I assume [I]you[/I] are?), so cannot contribute much based on experience. It does look, however, like you could not bother using that function, and just test whether or now mysqli_next_query() returns false or not.
Help with Troubleshooting
Ok here is the code I am using:
[code=php]
if (mysqli_more_results($link)) {
mysqli_next_result($link);
}
I am using this because I am running multiple stored procedures on the same page. The error I am getting is this:
[I]There is no next result set. Please, call mysqli_more_results()/mysqli::more_results() to check whether to call this function/method
Wouldn’t the above code do what it is asking me to do in the error? The error is coming on the line that is the mysqli_next_result($link) so that is the confusing part. Is mysqli_more_results() not working correctly or what could be the problem?
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogOct 03.2013 — #I've never used mysqli_multi_query() (I assume [I]you[/I] are?), so cannot contribute much based on experience. It does look, however, like you could not bother using that function, and just test whether or now mysqli_next_query() returns false or not.[code=php]
do {
// do stuff with a result set here...
// ...then:
} while (mysqli_next_result($link));
[/code]