Country: select_db('residential'); $result = $mysqli->query("SELECT country, id FROM country"); while($row = $result->fetch_array()) { print " {$row['country']} \n"; } print " \n"; $mysqli->close(); ?>