Ja. Sådan forstod jeg det også. (tror jeg
)
Men hvad er navnet på din row hvor timestampen er? Hvis det er "dato" burde det virke. Kan du ikke prøve at skrive hele koden?
ja navnet på row er dato.
her er hele koden for gæstebogphp, som jeg oprindeligt har lavet den:
<?php require_once('Connections/peki.php'); ?>
<?php
$maxRows_rsHentind = 30;
$pageNum_rsHentind = 0;
if (isset($_GET['pageNum_rsHentind'])) {
$pageNum_rsHentind = $_GET['pageNum_rsHentind'];
}
$startRow_rsHentind = $pageNum_rsHentind * $maxRows_rsHentind;
mysql_select_db($database_peki, $peki);
$query_rsHentind = "SELECT * FROM gæstebog ORDER BY id DESC";
$query_limit_rsHentind = sprintf("%s LIMIT %d, %d", $query_rsHentind, $startRow_rsHentind, $maxRows_rsHentind);
$rsHentind = mysql_query($query_limit_rsHentind, $peki) or die(mysql_error());
$row_rsHentind = mysql_fetch_assoc($rsHentind);
if (isset($_GET['totalRows_rsHentind'])) {
$totalRows_rsHentind = $_GET['totalRows_rsHentind'];
} else {
$all_rsHentind = mysql_query($query_rsHentind);
$totalRows_rsHentind = mysql_num_rows($all_rsHentind);
}
$totalPages_rsHentind = ceil($totalRows_rsHentind/$maxRows_rsHentind)-1;
mysql_select_db($database_peki, $peki);
$query_rsHenttekst = "SELECT * FROM gæstebogtekster";
$rsHenttekst = mysql_query($query_rsHenttekst, $peki) or die(mysql_error());
$row_rsHenttekst = mysql_fetch_assoc($rsHenttekst);
$totalRows_rsHenttekst = mysql_num_rows($rsHenttekst);
mysql_select_db($database_peki, $peki);
$query_rsDato = "SELECT Dato FROM gæstebog";
$rsDato = mysql_query($query_rsDato, $peki) or die(mysql_error());
$row_rsDato = mysql_fetch_assoc($rsDato);
$totalRows_rsDato = mysql_num_rows($rsDato);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Forside</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/link.css" rel="stylesheet" type="text/css" class="link">
<style type="text/css">
<!--
.style3 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
}
.style5 {
font-size: 5px;
color: #4C484D;
}
.style7 {
color: #4C484D;
font-style: italic;
font-size: 11px;
}
.style8 {color: #4C484D}
.style9 {font-size: 18px}
-->
</style>
</head>
<body><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><div align="right"><span class="dato"><a href="guestbook.php" class="undermenu"><strong>Gæstebogen</strong> </a><span class="style3">|</span> <a href="guestbook_opret.php" class="undermenu"> Opret indlæg</a> </span></div></td>
</tr>
<tr>
<td valign="top"><span class="tekstsort"> </span>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tekst">
<tr>
<td height="31" class="linksort"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="overskrift"></td>
</tr>
<tr>
<td valign="top" class="linksort"><p class="tekstsortstor"><strong><?php echo $row_rsHenttekst['overskrift']; ?></strong></p></td>
</tr>
<tr>
<td height="10" class="tekstsort"><?php echo $row_rsHenttekst['tekst']; ?></td>
</tr>
<tr>
<td height="29" class="linksort"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="43%" height="30" class="tekstsort"> </td>
<td width="57%" class="tekstsort"></td>
</tr>
<tr valign="top">
<td height="35" colspan="2" class="tekstsortstor style8"><div align="center" class="style9">
<div align="left">GÆSTEBOGEN...</div>
</div></td>
</tr>
<tr>
<td height="10" colspan="2"><?php do { ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="10" bgcolor="#FFFFFF" class="overskrift" align="left"><span class="style7"><?php echo $row_rsHentind['overskrift']; ?></span></td>
</tr>
<tr>
<td height="20" valign="top" class="dato"><div align="right" class="dato">
<div align="left"><em>Oprettet af <?php echo $row_rsHentind['navn']; ?><?php echo $row_rsHentind['dato']; ?> </div></td>
</tr>
<tr>
<td class="tekstsort"><em><?php echo $row_rsHentind['tekst']; ?></em></td>
</tr>
<tr>
<td height="45" class="tekstsortstor style8">...............</td>
</tr>
</table>
<?php } while ($row_rsHentind = mysql_fetch_assoc($rsHentind)); ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsHentind);
mysql_free_result($rsHenttekst);
mysql_free_result($rsDato);
?>