COUNT and NOW() problems

[vmusic]

Hi,
I am having a problem with a query I'm running through php. If I paste the query into the SQL window in phpAdmin it works fine.

The php code is:
$sql_statement = "SELECT COUNT(*) FROM SESSION WHERE session_exp >= NOW()";

Then I have a db call to
$result=mysql_query($sql_statement, $db_link);

I have changed the $sql_statement value and run all kinds of other queries. The query doesn't error out. But it returns zero and I know the count should be one. In fact if I cut and paste the same query above into the SQL window in phpAdmin it works fine, I get one column called COUNT(*) and it's value is 1.

I have even run other count queries with no problem. Somehow I think NOW() needs to be in quotes or someting?

Has anyone ran a mysql_query using a variable with NOW() in it?

Thanks In Advance.....

Vmusic

[iceraider]

Did you do..

$res = mysql_fetch_row($r);
$COUNT = $res[0];
echo $COUNT;

Append that

[vmusic]

I apologize. I didn't show that code....

Yes I get the result and 'fetch' the one single row. Then take the zero element just like you showed.

The result is the value zero, and I know it should be the value one. I am looking at the data in phpAdmin or mySQLAdmin

????????????????????????????

[YappyDog]

Try naming your result column like:

$sql_statement = "SELECT COUNT(*) as TotalRows FROM SESSION WHERE session_exp >= NOW()";