Compare the time using mysql

wxdqz

New Member
Dear all,

The following code have some mysql errors please give me a helping hand. thanks

Merry Christmas and Happy New Year,
Simon.
--------------------------------------

$sql="select * from led where btime=<'$totime'and etime=>'$totime'";

where $totime=date('h:i:s'), and both btime and etime are defined as time type.

The error message is

MySQL result resource in /home/htdocs/newtech/led/graph.php on line 20

----------------------------------------
 
Back
Top