Hi All,

Im having a problem, trying to do the following. I have a table which lists users domain names and when they registered them and how long for.

Now, when it comes to renewing the domains, it updates the date to the date in which they actually paid for the renewal, but i dont want this, i want it to add the ammount of years they have renewed for.

In the table i have domain_period_yr which is a numeric value of years and, domain_date.

What i want to happen is regardless of when they renew the domain it should just add the domain_period_yr to the date. i.e 2002-01-01 would become 2004-01-01 if the domain period was 2 years.

Any ideas how to achieve this would be much appreciated.
Regards

Mark
http://www.host4.me.uk

No doubt i'll be back for more answers!