PDO: mysql function NOW() not working ..

elemelas

does anybody know how can I get NOW() working through PDO layer ? it works perfectly with normal mysql, but doesn't with PDO ...

$query = $conn->prepare('SELECT * FROM events WHERE date>NOW() ORDER BY date ASC');

0777

all word in the ' ' Translate real word you most try by this Model:

$NowTime = strtotime("now");
$query = " SELECT * FROM `events` WHERE `date` > '$NowTime' ORDER BY `date` ASC ;";

Good Luck

elemelas

the only difference after using your example is that instead of no records im getting all of them displayed now, no matter what the date is (previously I wasn't getting anything) ...

this is the log from mysql if it helps anyhow:

SELECT * FROM 'events' WHERE 'date' > '1285537770' ORDER BY 'date' ASC

0777

first you most observe the mysql query syntax for external value you most quote by ' you can find this beside the ; and for internal for example table name and field quote ` you can find beside num1 ...

elemelas

as I said this is log from mysql db, not the syntax itself, so it is quoted ..

anyone has a solution for that ?

Pikachu2000

I believe you may be trying to compare a UNIX timestamp value to a YYYY-MM-DD date format . . . What is the data type of the date field?

elemelas

it's probably right, i was thinking that myself. but i previously tried this:

$date = date("Y-m-d");

but wouldn't work either .. date is a date 😉 (0000-00-00)

elemelas

any ideas any1 ?