Results 1 to 2 of 2

Thread: Help with Troubleshooting

  1. #1
    Join Date
    Feb 2012

    Help with Troubleshooting

    Ok here is the code I am using:

    PHP Code:
    if (mysqli_more_results($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
    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)); 
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

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