Short advice.

[xyn]

Hi.
Would someone be able to give me some advice on the easiest and
most effective way of going about checking account activations.
Basically when they register it will register the time and date, I wanted
to check if the account has been activated with in 15 days,

If it has obviosuly the time and date will become the "last login" otherwise
it would stay the registered date & time. Clearly this way would work using
MYSQL, but I have no idea how to go about it.

If the acocunt has not been activated within 15 days I wanted it to be
deleted automatically.

[leeming]

[quote author=xyn link=topic=103417.msg411733#msg411733 date=1155045459]
Hi.
Would someone be able to give me some advice on the easiest and
most effective way of going about checking account activations.
Basically when they register it will register the time and date, I wanted
to check if the account has been activated with in 15 days,

If it has obviosuly the time and date will become the "last login" otherwise
it would stay the registered date & time. Clearly this way would work using
MYSQL, but I have no idea how to go about it.

If the acocunt has not been activated within 15 days I wanted it to be
deleted automatically.
[/quote]

how is the date recorded? is it a datetime field, or set by time()

[xyn]

The date and time is set by:
date("d-m-y"); [nn-nn-nnnn]
date("g:ia");    [n:nam/pm]

[leeming]

some thing like this...

[code]
$borderdate = mktime(0, 0, 0, date("m"), date("d")-15 ,  date("Y"));  //15 days ago

mysql_query("DELETE FROM <table> WHERE `signup_date` =< '$borderdate');
[/code]

BUT... im only guessing, try running the same ish query but as a select, so see if it picks up the right members

[xyn]

I'll have a go.