Object	Procedural
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");	$link = mysqli_connect("localhost", "my_user", "my_password", "world");
$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";	$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";
$result = $mysqli->query($query);	$result = mysqli_query($link, $query);
$row = $result->fetch_array(MYSQLI_ASSOC);	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
$result->free(); /* close connection */ $mysqli->close();	mysqli_free_result($result); /* close connection */ mysqli_close($link);