counting days until a member's account expires

garethj

any ideas how to count the # of days unitl a users account expires? for instance if they have a 60 day membership to, i'd like to state the fact that their membership will expire on 01/20/03 etc..

thanks for the help.

leatherback

Hi,

if you are using MySQL, and you query the date of subscription from a table, you can use the date / time functions of Mysql,

http://www.mysql.com/doc/en/Date_and_time_functions.html

Here you have the option to add an interval in sec/min/hour/day/month/year to the selected date.

Else you could certainly use the mktime function of PhP to convert to unix time, and do calculations (For PhP without MySql there should eb an easier way, but I am unaware of it. Do a search on PhPbuilder. com! )