mysqli - PHP Certification question

[crmpicco]

I am currently studying towards my Zend PHP certification and have came across this question in my first practice exam:

Consider the following code-snippet, which is taken from a larger application:

<?php
for(/* empty */ ; 
    mysqli_more_results($link); 
    mysqli_next_result($link))
{

  if($result = mysqli_store_result($link))
  {
    while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
    {
      foreach($row as $value)
      {
        print "$value\n";
      }
    }
    mysqli_free_result($result);
  }
}
?>

Can anyone advise - this is an example of doing what using the new MySQLi extension?

The possible answers are:

Performing a multi-query statement
Performing a transaction
Using an unbuffered queries
Prepared Statements
Using buffered queries

Many thanks,
Picco

[Jona]

Looks like option #1 to me, "Performing a multi-query statement."

See: mysqli::multi_query().

[NogDog]

Hint: read up on mysqli::more_results().