Page 2 of 2

Posted: Fri Oct 01, 2004 11:07 am
by Harlequin
OK Scott - Thanks for your time on this by the way. Here's what I have:

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);
Which I assume will do the following:

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]