select_db('residential'); // (3) run a query on the country table $result = $mysqli->query("SELECT * FROM country"); // (4) fetch each row while($row = $result->fetch_array(MYSQLI_ASSOC)) { // (5) for each attribute in a row foreach ($row as $attribute) { print $attribute . " "; } print "
\n"; } $mysqli->close(); ?>