<?php $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'].")<br />"; if (sqlite_has_more($results)) echo "Still more rows to go!<br />"; else echo "No more rows!<br />"; } sqlite_close($sqldb); ?>