MySQL Forums
Forum List  »  Newbie

Selecting a time range
Posted by: Grant Holmes
Date: January 03, 2008 02:03PM

Hi gang. Ima Newbie and stuck. I'm trying to display active records in a table on my web page. However, to minimize maintenance, I only want to display records that are up to 48 hours old at any point. Here's my code so far:
$query="SELECT * from birthdays where Active='1' AND Event='request' AND hour(DateEntered)< 48";
Where "Active" is a flag at 1/0..."Event" is populated and "DateEntered" is a system TimeStamp of the record creation.

I have 11 Active records and 5 that are 48 hours old, or less, so my page should return 5 records. It's returning all 11.

Any help?

Options: ReplyQuote

Written By
Selecting a time range
January 03, 2008 02:03PM
January 03, 2008 03:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.