<?php $sqldb = sqlite_open("mydatabase.db"); $results = sqlite_query($sqldb, "SELECT * FROM employee"); echo "Total rows returned: ".sqlite_num_rows($results)."<br />"; sqlite_close($sqldb); ?>