Codice PHP:
<?php
$mysqli 
= new mysqli("localhost""root""""showcase");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n"mysqli_connect_error());
    exit();
}

$query  "SELECT * FROM wpterms;";
$query .= "SELECT * FROM wpusers;";

/* execute multi query */
if ($mysqli->multi_query($query)) {
    do {
        
/* store first result set */
        
if ($result $mysqli->store_result()) {
            while (
$row $result->fetch_row()) {
                
printf("%s\n"$row[0]);
            }
            
$result->free();
        }
        
/* print divider */
        
if ($mysqli->more_results()) {
            
printf("-----------------\n");
        }
    } while (
$mysqli->next_result());
}

/* close connection */
$mysqli->close();
?>
per esempio provando questo


mi da come risultato questo:

codice HTML:
1 ----------------- 1 
Strict Standards:  mysqli::next_result(): There is no next result  set. Please, call mysqli_more_results()/mysqli::more_results() to check  whether to call this function/method in C:\EasyPHP\data\localweb\test.php on line 28