In addition to being able to retrieve single row & column data as a string sqlite_single_query() can be a convenient tool for fetching multi-row results. 

<?php
chdir(dirname(__FILE__)); // pres2 hack

$db = sqlite_open("./ip.db");
$result = sqlite_single_query("SELECT country_name FROM country_data WHERE country_name LIKE 'U%'", $db);
foreach ($result as $country) {
    echo $country . "<br />\n";
}
?>
Output