notify before expiration date
Posted: Tue Mar 15, 2005 5:05 pm
hello,
pls help with the folloeing.
I have a table
[users]
id
user_name
date_added
exp_date
the problem is like this:
let's say I add a new user and he's expiration date is 1 year after the day he was added.
In notify.php i want to display the users that there expiration date is in less that 7 days from today's date, because I want to be able to contact them and tell them that they should log in again or something like this.
I know how to display the users in notify.php that have the today() date equal with the expiration date but this doesn't makes me happy.
this should be something like this:
select * from users where ((exp_date - date()) < 7).
I know i didn't explain my self to clear, but i hope you understand.
thx.
pls help with the folloeing.
I have a table
[users]
id
user_name
date_added
exp_date
the problem is like this:
let's say I add a new user and he's expiration date is 1 year after the day he was added.
In notify.php i want to display the users that there expiration date is in less that 7 days from today's date, because I want to be able to contact them and tell them that they should log in again or something like this.
I know how to display the users in notify.php that have the today() date equal with the expiration date but this doesn't makes me happy.
this should be something like this:
select * from users where ((exp_date - date()) < 7).
I know i didn't explain my self to clear, but i hope you understand.
thx.