tired brain and date comparisons...

[danielle]

not sure what's going on... i know this is something silly but my brain isn't working so well.

i have a date called $renewdate split into renew_mon, day and yr. Using the current date, I want to be able to pull up the list of users and get the accounts expiring 30 days or less from today and another list of "expired" accounts.

i can calculate the difference easy enough but i'm stuck on the after the date is past part....

if i do this:
$current_day= date ("j");
$current_mon= date ("n");
$current_yr= date ("Y");

$diff = abs(mktime(0,0,0,$renew_mon,$renew_day,$renew_yr) - mktime(0,0,0,$current_mon,$current_day,$current_yr)) / (86400);

i get the correct # but if i set it up to say
if ($diff < 31 && $diff >=1) echo "time to renew your account";
if ($diff >1) echo "account expired";

then it shows "renew" for 30 days before and after and account is only expired on the actual renewal date. 31 days after expiration it doesn't catch...

[bubblenut]

Here's a list of assumptions I'm making, if any of them a wrong please let me know.
You have all the account information in some kind of database system (be that RDBMS, flat files, etc)
This if for some maintenance page which will show up all the users and mark those which are getting near to the expiration date, and those which are now expired.

With those assumptions in place, here goes.

You want some kind of timestamp column in the accounts table. Then to display, assuming you're using MySQL, you'd do something like the following.

<?php
//In the where clause (86400*25) is how many seconds there are in 25 days
$sql="SELECT unique_id, username, timestamp FROM table WHERE timestamp<".(time()-(86400*25))." ORDER BY timestamp";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res)) {
  if($row['timestamp']<(time()-(86400*30))) {
  $message="Account has expired";
  //kill the account
} else {
  $message="Account is nearing it's end";
}
  echo($row['unique_id'].": ".$row['username']."&nbsp;&nbsp;".$message."<br />\n");
}
?>

Is that what you were trying to do?
HTH
Bubble

[danielle]

yup that's pretty much it!

the thing is, the dates in the database aren't timestamps -- they are just varchars like 2/25/2004. i'm trying to do it in just php.

we need to have both a list generated of users up for renewal and about to expire like you said. also show this info when you go to an individual user's account page.

[danielle]

ok i'm an idiot!

i had the result set to give the absolute value with abs.

without that the result is negative after the account expires.

:rolleyes: