MySQL timestamp bliver til 2038
Hvordan får jeg dette timestamp i databasen(20040313133344) til at se pænt ud i en echo? Den formaterer det som år 2038..Hvorfor?Det er feltet data_pub som indeholder datofeltet.
<?php require_once('../Connections/afx.php'); ?>
<?php
mysql_select_db($database_afx, $afx);
$query_Recordset1 = "SELECT * FROM temp ORDER BY id DESC LIMIT 1";
$Recordset1 = mysql_query($query_Recordset1, $afx) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>showtemp</title>
<link href="/css/greenstyle2.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="82%" border="0" align="center">
<tr>
<td width="18%">Navn:</td>
<td width="24%"><?php echo $row_Recordset1['name']; ?></td>
<td width="26%">Billede:</td>
<td width="32%"> </td>
</tr>
<tr>
<td>Adresse:</td>
<td><?php echo $row_Recordset1['street']; ?></td>
<td rowspan="5"><?php echo $row_Recordset1['picture']; ?></td>
<td> </td>
</tr>
<tr>
<td>Postnr. og by</td>
<td><?php echo $row_Recordset1['postnumber']; ?><?php echo $row_Recordset1['city']; ?> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Telefon:</td>
<td><?php echo $row_Recordset1['telephone']; ?></td>
<td> </td>
</tr>
<tr>
<td>Mobil:</td>
<td><?php echo $row_Recordset1['mobile']; ?></td>
<td> </td>
</tr>
<tr>
<td>Fax:</td>
<td><?php echo $row_Recordset1['fax']; ?></td>
<td>CPR nr.</td>
<td><?php echo $row_Recordset1['cpr_number']; ?></td>
</tr>
<tr>
<td>E-mail:</td>
<td><?php echo $row_Recordset1['e_mail']; ?></td>
<td>Land:</td>
<td><?php echo $row_Recordset1['country']; ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>Køn:</td>
<td><?php echo $row_Recordset1['sex']; ?></td>
</tr>
<tr>
<td>Transport:</td>
<td><?php echo $row_Recordset1['transport']; ?></td>
<td>Oprettet:</td>
<td><?php echo date("d-m-Y", $row_Recordset1['data_pub']); ?></td>
</tr>
<tr>
<td>Ryger:</td>
<td><?php echo $row_Recordset1['smoking']; ?></td>
<td>Tilknyttet afdeling:</td>
<td><?php echo $row_Recordset1['dep_connect']; ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>Tilknyttet konsulent:</td>
<td><?php echo $row_Recordset1['resp_contact']; ?></td>
</tr>
<tr>
<td>Arbejdsområder:</td>
<td><?php echo $row_Recordset1['work_areas']; ?></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Aktiv/Inaktiv:</td>
<td><?php echo $row_Recordset1['active_inactive']; ?></td>
<td>Fagforening:</td>
<td><?php echo $row_Recordset1['union']; ?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>A-kasse:</td>
<td><?php echo $row_Recordset1['a_box']; ?></td>
</tr>
<tr>
<td>Noter:</td>
<td colspan="3"><?php echo $row_Recordset1['notes']; ?></td>
</tr>
</table>
<div align="center"></div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
