$sqldb = sqlite_open("mydatabase.db");
$results = sqlite_query($sqldb, "SELECT * FROM employee");
while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) {
echo "Name: $row[1] (Employee ID: ".$row['empid'].")
if (sqlite_has_more($results)) echo "Still more rows to go!
else echo "No more rows!
}
sqlite_close($sqldb);
?>