[RESOLVED] Converting Timestamps

[Joe127]

Hi,

I am converting unix timestamps to date form in my MySQL database. I keep getting this error:

Parse error: syntax error, unexpected ';' in /home/absence1/public_html/remote/RUN-ONCE.php on line 23

I cant work out why as there is already a ';' present at the end of the line.

Line 23:

		$MySQLrenewalDate = date( 'Y-m-d', $PHPTSrenewalDate );

Full code:

<?php

$query="SELECT * FROM quotations";
$result=mysql_query($query);
$num=mysql_numrows($result);

$i=0;

while ($i < $num) {

$quoteID=mysql_result($result,$i,"ID");

$PHPTScoverDate=mysql_result($result,$i,"CoverTimeStamp");
$PHPTSrenewalDate=mysql_result($result,$i,"RenewalTimestamp");
$PHPTSquotationDate=mysql_result($result,$i,"QuotationTimeStamp");

$MySQLcoverDate = date( 'Y-m-d', $PHPTScoverDate );
$MySQLquotationDate = date( 'Y-m-d', $PHPTSquotationDate );

if ($PHPTSrenewalDate == "") {
	$queryLoop = "UPDATE quotations SET MySQLQuotationTimeStamp='$MySQLquotationDate', MySQLCoverTimeStamp='$MySQLcoverDate' WHERE ID='$quoteID'";
} else (
	$MySQLrenewalDate = date( 'Y-m-d', $PHPTSrenewalDate );
	$queryLoop = "UPDATE quotations SET MySQLQuotationTimeStamp='$MySQLquotationDate', MySQLCoverTimeStamp='$MySQLcoverDate', MySQLRenewalTimestamp='$MySQLrenewalDate' WHERE ID='$quoteID'";
}

mysql_query($queryLoop);

$i++;

}

echo "$i records updated.";
?>

[Pikachu2000]

The only error I see in there is the else:

 } else ( 

[Joe127]

Thats what it was, thanks!

I have been looking at this for the past hour, I hate typo's!