Query Help....

[donm1021]

I have a Membership database and I trying to write a MySQL query that will print a message out to the screen when a member logs in to let them know that their membership is about to expire within the next 30 days.

I have a field called "date_exp" which contains each members membership expiration date. How do I compare once they login, their expiration date (date_exp) against the current date and determine if their membership will expire within the next 30 days and then print a message out to the screen in HTML?

Any help in getting me started in the right direction would be much appreciated.

 

[piti]

try something like this
select TO_DAYS(date_exp)-TO_DAYS(NOW()) FROM table
that should return the number of days remaining