Code: Select all
$sql = $sql1.$sql2.$sql3;
if ($mysqli->multi_query($sql))
{
do
{
/*
switch ($mysqli->queryNumber)
{
case 1: ... break; # $sql1
case 2: ... break; # $sql2
case 3: ... break; # $sql3
}
*/
if ($result = $mysqli->store_result())
{
while ($row = $result->fetch_assoc())
{
echo $row['Name'].'<br/>';
}
}
if ($mysqli->more_results())
echo '<hr/>';
} while ($mysqli->next_result());
}
else
{
echo $mysqli->errno." : ".$mysqli->error;
}