Php pdo prepare return empty row, 1 row expected, why?

[colap]

<?php

require_once 'functions.php';

$dbh = mysql_connection();

$email_token = $_REQUEST['email_token'];
$objDateTime = new DateTime('NOW');
$current_datetime = $objDateTime->format("Y-m-d H:i:s");

$statement = $dbh->prepare("select * from p_users where email_token=:email_token and email_token_expiry>:current_datetime");

$result = $statement->execute(array(':email_token'=>$email_token, ':current_datetime'=>$current_datetime) );
$rc = $statement->rowCount();

From database:

mysql> select id,username,email,email_token,email_token_expiry from p_users;
+----+----------+----------------------+-------------+---------------------+
| id | username | email                | email_token | email_token_expiry  |
+----+----------+----------------------+-------------+---------------------+
|  7 | abc   | [email protected] | krl5g085wy  | 2014-04-12 08:18:33 |
+----+----------+----------------------+-------------+---------------------+
1 row in set (0.00 sec)

What can be the reason to get zero row? How can i debug pdo statement?

[tunage]

what does 'select * from p_users;' say?

Is there only one record in the db?

[colap]

what does 'select * from p_users;' say?

Is there only one record in the db?

 

Yes, there is only one row/record for this table.

[mac_gyver]

what does using var_dump($email_token); show?