/* Send a query to the server */
if ($result = mysqli_query($link, 'SELECT * FROM City')) {

print("Very large cities are:\n");

/* Fetch the results of the query */
while( $row = mysqli_fetch_assoc($result) ){
printf("%s (%s)\n", $row['Name'], $row['Population']);
}
/* Destroy the result set and free the memory used for it */
mysqli_free_result($result);
}
mysqli_close($link); /* Close the connection */
?>