没有下一个结果集。 请调用mysqli_more_results（）/ mysqli :: more_results（）来检查是否要调用此函数/方法

Question

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));

Am getting the following error:

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

What should I do?

Answer 1

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;
    }
}