Query number in mysqli_multi_query iteration
Posted: Fri Feb 15, 2008 11:40 am
When using mysqli_multi_query, is there a way to find out the current query ($sql1, $sql2 or $sql3) while iterating ?
Thanks
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;
}