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:
Where "Active" is a flag at 1/0..."Event" is populated and "DateEntered" is a system TimeStamp of the record creation.Code:$query="SELECT * from birthdays where Active='1' AND Event='request' AND hour(DateEntered)< 48";
I have 11 Active records total that are active and 5 that are active AND 48 hours old, or less, so my page should return 5 records. It's returning all 11.