www.webdeveloper.com
Results 1 to 2 of 2

Thread: Help with Troubleshooting

  1. #1
    Join Date
    Feb 2012
    Posts
    102

    Help with Troubleshooting

    Ok here is the code I am using:

    PHP Code:
    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:

    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?
    Owner of Reality TV Addict
    Publisher of Strategies for Stretching Your Income (ebook)
    CEO and Founder of Sport Directions
    Follow me at @RealityTV_Forum

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,176
    I've never used mysqli_multi_query() (I assume you 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.
    PHP Code:
    do {
        
    // do stuff with a result set here...
        // ...then:
    } while (mysqli_next_result($link)); 
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles