the date and mysql

[christophe]

Hi there

before i begin ill explain what i am doing,

I register domain names for people and businesses i know.

I have a form which allows me to put in the domain name and the day the domain name  has to be renewed.

So what i need is to get this renewal date from the database and take away 30 days. So I know 30 days in advance that the name has to be renewed.

Could someone point me in the right direction

Any help will be much appreciated

Thanks
Alex

[Jessica]

[code]
<?php
$thirtyDays = 60*60*24*30;

//If your date is stored as integer timestamp
$renewal = $date-$thirtyDays;
//If it's DATE/DATETIME
$renewal = strtotime($date)-$thirtyDays;
?>[/code]