Date formatting from a mySQL timestamp

Hi, I have the following query : for($i = 0; $i <=$num_results; $i++) { $row = mysql_fetch_object($result); echo "<table width =\"100%\" border =\"0\" cellpadding = \"3\">\n" ."<tr>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->id</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Nombre</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Apellido</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Direccion</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Ciudad</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Telefono</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Mail</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Pais</td>\n" ."<td bgcolor = \"#eeeeee\" align = \"left\">".date("r", $row->date)."<td>\n" // My problem is it's getting the wrong date no matter what I do, every line displays Jan 2038 !!! ."</tr>\n" ."</table>\n"; If I try another strings i got errors the row $date is in MYSQL unix timestamp. and i would like to format it. BTW I would like a better alignment and format also ... TIA Regards, Rick