mysqli_fetch_array1.htm
 
 
<?php
//$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$mysqli = new mysqli("Manas9", "Manas9", "Manas9237", "test");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

$query = "SELECT CURRENT_USER();";
$query .= "SELECT fname, lname FROM emp1 ORDER BY fname";

/* execute multi query */
if ($mysqli->multi_query($query)) {
do{
/* store first result set */
if ($result = $mysqli->use_result()) {
while ($row = $result->fetch_row()) {
echo("<br/>". $row[0]."&nbsp". $row[1]);
}
$result->close();
}

} while ($mysqli->next_result());
}

/* close connection */
$mysqli->close();
?>