mysqli_multi_query() only returns FALSE if the first statement failed. To retrieve subsequent errors from other statements you have to call
mysqli_next_result() first.
$query ="SELECT CURRENT_USER();"; $query.="SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* 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->close();
} /* print divider */ if ($mysqli->more_results())
{ printf("-----------------\n");
}
} while ($mysqli->next_result());
}
$query ="SELECT CURRENT_USER();"; $query.="SELECT Name FROM City ORDER BY ID LIMIT 20, 5";
/* execute multi query */ if (mysqli_multi_query($link,$query)) {
do { /* store first result set */ if ($result=mysqli_store_result($link)) {
while ($row=mysqli_fetch_row($result)) { printf("%s\n",$row[0]);
} mysqli_free_result($result);
} /* print divider */ if (mysqli_more_results($link))
{ printf("-----------------\n");
}
} while (mysqli_next_result($link));
}