Hello,
I want to select two dates one being todays date and the other being
0000-00-00 which just a date
in the database when no proper date has been entered.
Ive tried this but it does not work...
$today = date('Y-m-d');
$result = sqlite_query($db, "SELECT * FROM domains WHERE date = '0000-00-00'
AND '$today'");
I just get items with '0000-00-00' returned or if I reverse it ie...
WHERE date = '$today'AND '0000-00-00'");
I just get $today items returned.
I also tried using OR instead of AND ie...
WHERE date = '0000-00-00' OR '$today'");
But that seems to be returning all items in the db.
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
