Hello
I am using SQLite and it seems a lot of the SQL and PHP code is different to the MySQL that W3 mentions. I have tried many combinations and through trial and error achieved most of what I need to know, but I am stuck on this one bit.
I am trying to filter a database (SQLite) so that the only records shown are after the current time. I have set the datafield as 'numeric' in SQLite, I have used PHP/ SQL to write the current time to the database, in order to make sure I was using a compatible time format.
<!DOCTYPE html>
<html>
<body>
<?php
$timenow = date("h:i");
$db = new SQLite3('phptest2.db');
$res = $db->query('SELECT * FROM times where timings > $timenow ');
while ($row = $res->fetchArray()) {
echo "{$row['location']} {$row['time']}\n <br>";
}
echo "hello $timenow";
?>
</body>
</html>
On the basis that I can write and filter based on other variables and constants, I am inclined to think this is some error in the way I'm interrogating SQLite with the SQL above. I have added in the bottom 'echo' just to make sure it was picking up and recording the current time, which it is. I have tried it with all manner of ' and " around the variable (I expected it to be ' ' but it wasn't.)
I apologise for such a basic question. I have exhausted all options- none of the search engine results give any working examples to help (at least not that I can understand).
Please be assured that I'm not trying to be lazy. I've learned HTML and CSS from this brilliant site over the years, and recently gone from 0 to 'advanced beginner' with Pascal (again using SQLite), so learning plenty and now trying SQL and PHP as well.
If anyone could point me in the right direction, with either help or a suggestion of a site, I would be most appreciative.
Many thanks
Derek
