没有下一个结果集.请调用mysqli_more_results()/mysqli :: more_results()检查是否调用此函数/方法 [英] There is no next result set. Please, call mysqli_more_results()/mysqli::more_results() to check whether to call this function/method

问题描述

我已经完成了下面使用php5.2和mySql 5进行编码的工作.现在，我已经升级了服务器以支持php 5.3和mySql 5.1.

I've done below coding using php5.2 and mySql 5. Now I've upgraded my server to support php 5.3 and mySql 5.1.

    do
    {
        if ($this->Result = mysqli_store_result($this->LinkId))
        {
             while ($row = mysqli_fetch_array($this->Result , MYSQLI_ASSOC))
             {
                  $arrRes[] = $row;
             }
             mysqli_free_result($this->Result);
        }
    }while (mysqli_next_result($this->LinkId));

我遇到以下错误:

没有下一个结果集.请调用mysqli_more_results()/mysqli :: more_results()检查是否调用此函数/方法

There is no next result set. Please, call mysqli_more_results()/mysqli::more_results() to check whether to call this function/method

我该怎么办?

推荐答案

您可能想做这样的事情.

You probably want to do something like this.

while (true) {
    if ($this->Result = mysqli_store_result($this->LinkId)) {
        while ($row = mysqli_fetch_array($this->Result , MYSQLI_ASSOC)) {
            $arrRes[] = $row;
        }
        mysqli_free_result($this->Result);
    }
    if (mysqli_more_results($this->LinkId)) {
        mysqli_next_result($this->LinkId);
    } else {
        break;
    }
}

这篇关于没有下一个结果集.请调用mysqli_more_results()/mysqli :: more_results()检查是否调用此函数/方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！