Need SQL help!!

Folks,

I'm trying to get data out of a table that has one field for date, and one field for time. Both field types are tinyint.

I need to get the past 24 hours of data out of it. I've tried the below query with no luck.

select event.eventdate, event.eventtime, signature.eventname from event INNER JOIN signature ON (event.sigid = signature.sigid) where event.sensorid = 16 and event.sigid = 51 and eventdate = '2004-08-26' and eventtime >= '08:14:41' and eventdate = '2004-08-27' and eventtime <= '08:14:41';

Is there some other way I can query this stuff?

MySQL Version info: Ver 12.18 Distrib 4.0.12, for pc-linux (i686)

Thanks for your help!

Steve