Code: Select all
// Select Dormant Users Older Than 7 Days:
$Query08 = "SELECT * FROM MembersData
WHERE DATE_SUB('$RegistrationDate',INTERVAL 7 DAY)";
$Result08 = mysql_query($Query08) or die("Error 08: " . mysql_error());
$VeryDormantUsers = mysql_result($Result08, 0);Grabe the variable $RegistrationDate from a query I execute before this and only return the records where the value for $RegistrationDate is greater than 7 days.
I'm working on the assumption that I will need an IF nelow here to grab the records where the $RegistrationDate is greater than 7 days old, Nope...?
Something like:
IF $Now - $RegistrationDate > 7 DAYS
{
Do Something
}
I dunno.
feyd | use
Code: Select all
tags![/color]