Hard, having to do with dates.

[Anon]

I have the following code:

while (($id == 0) || ($id == $oldid) || ($date =)
{
	$check = mysql_query("select * from user where active=1 and inrotation = 1");
	$rows = mysql_num_rows($query);
	$row = rand(0, $rows);
	mysql_data_seek($check, $row);
	$record = mysql_fetch_array($query);
	$id = $record["id"];
}

To the While statement I want to check a date checking thingie that autoupdates.. I.e, if it finds a user id that is a month or more older it will Update inrotation = 0 via mysql. Anyhelp?

[Anon]

I think I got it,

$signup = $record["signupdate"];
$vars = implode("/", $signup);
$currentdate = implode("/", $currentdate);
$currentdate += 100;
if($vars >= $currentdate)
{
mysql_query("UPDATE user SET active = 0 WHERE id = $id ");
$ok = "0";
}

I know it can be improved, or does this even work?

[brandonschnell]

i haven't tried it, but something like the below should work:

create table user (id int auto_increment primary key, active enum('Y','N'),username varchar(255), password varchar(255), last_account_access timestamp)

UPDATE user SET active = 'N' WHERE NOW() > DATE_ADD(last_account_access, INTERVAL 3 MONTH);