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