das klappt auch nicht so richtig
im folgenden steht nun der komplette code freue mich über weitere lösungsvorschläge und zugehörige erklärungen
<?php require_once('Connections/florida_connection.php'); ?>
<?php
$colname_chronik = "1";
if (isset($_GET['CONT_ID'])) {
$colname_chronik = (get_magic_quotes_gpc()) ? $_GET['CONT_ID'] : addslashes($_GET['CONT_ID']);
}
mysql_select_db($database_florida_connection, $florida_connection);
$query_chronik = sprintf("SELECT ID, `day`, headline, content, image, Unterkunft, `Preis pro Nacht`, Empfehlungen FROM chronik WHERE ID = %s", $colname_chronik);
$chronik = mysql_query($query_chronik, $florida_connection) or die(mysql_error());
$row_chronik = mysql_fetch_assoc($chronik);
$totalRows_chronik = mysql_num_rows($chronik);
mysql_select_db($database_florida_connection, $florida_connection);
$query_navi = "SELECT `day` FROM navi_chronik";
$navi = mysql_query($query_navi, $florida_connection) or die(mysql_error());
$row_navi = mysql_fetch_assoc($navi);
$totalRows_navi = mysql_num_rows($navi);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd">;
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title></title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<link href="sitelayout.css" rel="stylesheet" type="text/css">
<link href="chronik_layout.css" rel="stylesheet" type="text/css">
<link href="navi_hotels_motels.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="985" border="0" cellpadding="0" cellspacing="0" class="navileft_class">
<!--DWLayoutTable-->
<tr>
<td width="58" height="30"> </td>
<td width="861"> </td>
<td width="66"> </td>
</tr>
<tr>
<td height="107"> </td>
<td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="861" height="107" valign="top"><img src="images/sun_logo.png" width="861" height="109"></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td height="13"></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="18"></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="861" height="18" valign="top" class="links">
<a href="attractions.php">Tagebuch<a> </a><a href="index.php">Sehenswürdigkeiten</a> <a href="hotels_motels.php">Hotels&Motels</a> <a href="route.php">Route</a> <a href="tips.php">Tips&Tricks</a> <a href="shopping.php">Shoppingguide</a> </td>
</tr>
</table></td>
<td></td>
</tr>
<tr>
<td height="34"></td>
<td> </td>
<td></td>
</tr>
<tr>
<td height="535"></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="172" height="535" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="124" height="239" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="124" height="20" valign="top" class="menu">
/php teil für die dynamischen links die aus der datenbank gelesen werden. Jeder link der aus der db gelesen wird soll auf einen neuen bericht verweisen/
<?php do { ?>
<a href="tagebuch.php?<?php echo $row_navi['day']; ?>=cont_id"><?php echo $row_navi['day']; ?></a>
<?php } while ($row_navi = mysql_fetch_assoc($navi)); ?>
</td>
</tr>
<tr>
<td height="235"> </td>
</tr>
</table></td>
<td width="48"> </td>
</tr>
<tr>
<td height="296"> </td>
<td> </td>
</tr>
</table></td>
<td width="34"> </td>
<td width="655" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="19" colspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="114" height="19" valign="top" class="day">
/hier soll dann aus der db das feld day ausgelesen werden/
<?php echo $row_chronik['day']; ?>
</td>
<td width="544" valign="top" class="day">
/hier soll dann aus der db das feld headline ausgelesen werden/
<?php echo $row_chronik['headline']; ?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td width="325" height="18"></td>
<td width="20"></td>
<td width="310"></td>
</tr>
<tr>
<td height="154" colspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="655" height="21" valign="top" class="content">
/hier soll dann aus der db das feld content ausgelesen werden/
<?php echo $row_chronik['content']; ?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="26"> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="92" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="325" height="22" valign="top" class="lodge">
/hier soll dann aus der db das feld unterkunft ausgelesen werden/
<?php echo $row_chronik['Unterkunft']; ?>
</td>
</tr>
<tr>
<td height="51"> </td>
</tr>
<tr>
<td height="19" valign="top" class="todo">
/hier soll dann aus der db das feld empfehlungen ausgelesen werden/
<?php echo $row_chronik['Empfehlungen']; ?>
</td>
</tr>
</table></td>
<td> </td>
<td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="310" height="240" valign="top">
/hier soll dann aus der db das feld picture ausgelesen werden/
<img src="<?php echo $row_chronik['image']; ?>" alt="" name="" class="pics">
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="148"> </td>
<td> </td>
</tr>
<tr>
<td height="78"> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr> </table></td>
<td></td>
</tr>
<tr>
<td height="165"></td>
<td> </td>
<td></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($chronik);
mysql_free_result($navi);
?>