In this article, we will focus on the mysqli_more_results() function in PHP, which is used to check if there are more results from a multi-query execution. We will provide you with an overview of the function, how it works, and examples of its use.

Introduction to the mysqli_more_results() function

The mysqli_more_results() function is a built-in function in PHP that is used to check if there are more results from a multi-query execution. This function is useful when you need to execute multiple queries and retrieve all the results.

How to use the mysqli_more_results() function

Using the mysqli_more_results() function is very simple. You just need to call the function on a valid MySQLi connection. Here is an example:

$mysqli = mysqli_connect("localhost", "username", "password", "database");

mysqli_multi_query($mysqli, "SELECT * FROM table1; SELECT * FROM table2;");

do {
    if ($result = mysqli_store_result($mysqli)) {
        // Process result set
} while (mysqli_more_results($mysqli) && mysqli_next_result($mysqli));


In this example, we call the mysqli_connect() function to connect to a MySQL database with a username and password. We then execute two SELECT queries using the mysqli_multi_query() function. We then use a do-while loop to process each result set returned by the queries using the mysqli_store_result() function. We then check if there are more results using the mysqli_more_results() function and move to the next result set using the mysqli_next_result() function. We then close the MySQLi connection using the mysqli_close() function.


In conclusion, the mysqli_more_results() function is a useful tool for checking if there are more results from a multi-query execution. By understanding how to use the function, you can take advantage of this feature to create powerful and efficient MySQLi queries.

Practice Your Knowledge

What is the mysqli_num_rows() function used for in PHP?

Quiz Time: Test Your Skills!

Ready to challenge what you've learned? Dive into our interactive quizzes for a deeper understanding and a fun way to reinforce your knowledge.

Do you find this helpful?