<?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 />"; } sqlite_close($sqldb); ?>