Thanks, didnt realise it was that simple! For some reason though this keeps outputting 01/01/2010.
<?
$schoolID=$_POST['schoolID'];
$query="SELECT * FROM clients WHERE ID='$schoolID'";
$result=mysql_query($query);
$renewalDate=mysql_result($result,0,"renewalDate");
if ($numrows == 0) {
$dateDD=1;
$dateMM=date("m"+1);
$dateYYYY=date('Y');
} else {
$dateDD=date("d", $renewalDate);
$dateMM=date("m", $renewalDate);
$time = mktime(23, 59, 59, $dateMM, $dateDD, date('Y'));
if($time < time())
{
$dateYYYY=date('Y'+1);
} else {
$dateYYYY=date('Y');
}
}
?>