connect_errno) { printf("Connect failed: %s\n", $mysqli->connect_error); exit(); } $query = "SELECT * FROM `location`"; if ($result = $mysqli->query($query)) { /* fetch associative array */ while ($row = $result->fetch_assoc()) { printf ("%s (%s)\n", $row["name"], $row["date"]); } /* free result set */ $result->free(); } /* close connection */ $mysqli->close(); ?>