Any idea why this won't run?

[buzzt]

I am trying to run the following from a PHP page:

$exthr = mysql_query("select extract(hour from '19:00')"
echo $extr;

It does not seem to work. I end up with

Resource id #4

Yet if I type:

select extract(hour from '19:00');

at the mysql command line, it does. Any idea why PHP is not running this?

 

[swampBoogie]

mysql_query returns a handle that should be used when fetching the data with mysql_fetch_array or mysql_fetch_row. It does not return any data.

 

[KarveR]

echo $extr[0]; ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.