PHP/MySQL Database/sqlite column
sqlite_column.php
<source lang="html4strict">
<?php
$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);
?>
</source>