$sqldb = sqlite_open("mydatabase.db");
$results = sqlite_query($sqldb,"SELECT * FROM employee WHERE empid = '1'");
$name = sqlite_column($results,"name");
$empid = sqlite_column($results,"empid");
echo "Name: $name (Employee ID: $empid)
sqlite_close($sqldb);
?>