$sqldb = sqlite_open("mydatabase.db"); $rows = sqlite_array_query($sqldb, "SELECT empid, name FROM employee"); foreach ($rows AS $row) { echo $row["name"]." (Employee ID: ".$row["empid"].")"; } sqlite_close($sqldb);?>