Authenicate based on when purchased

[bschultz]

I have an authentication system set up for ensuring that  a person has purchased an audio stream prior to gaining access to the stream.  I need to modify it slightly.  Currently, I check to make sure that they purchased on today's date.

 

while ($row1 = mysql_fetch_assoc($result1)) {

session_register("myemail");
echo "<meta http-equiv=Refresh content=1;url='page.php?page=seasonticket'>";   
}
$sql2 = "SELECT customers_email_address, date_purchased, order_total FROM orders WHERE customers_email_address = '$_POST[myemail]' AND order_total = '5.00' AND date_format(date_purchased, '%Y-%m-%d') = CURRENT_DATE";

$result2 = mysql_query($sql2);

if (!$result2) {
   echo "Could not successfully run query ($sql2) from DB: " . mysql_error();
   exit;
}

if (mysql_num_rows($result2) == 0) {
   
echo "<meta http-equiv=Refresh content=5;url='page.php?page=noticket'>";
   
}

 

How would I modify the select statement to check to see if a purchase has been made in the last 24 hours...not just today's date?

 

Thanks.

 

[fenway]

WHERE date_purchased >= NOW() - INTERVAL 24 HOUR

[bschultz]

Thank you...

[fenway]

Or "1 DAY", depending on what you actually mean.