time comparison

[fnbcprog]

I need a function that will compare time from a return result.

If my database returns something like 12:00 I want to be able to test whether this was more than one hour before the current time.

i.e.

currentTime = 1:00;
returnedTime = 11:00

The returned time is over an hour before the current time return true...else return false

[jkohns]

in your select, use

SELECT HOUR(`time`) as `hour`...[code]
where `time` is the field containing the time element...then in php

[code=php]
if ($result['hour'] < (date('H') - 1){
  print 'TRUE';
}else{
 print 'FALSE';
}

[fnbcprog]

Does the field type have to be a specific form to select hour on?

[jkohns]

it should be a time-type field