Her er den samlede kode:
Det fylder en del og er måske lidt svært at overskue:
---------------------------------------------------------------------------
<?
session_start();
include("database.php");
include("onlinecheck.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<!-- Minus AutoDato -->
<title>MUSIKVIDEN.DK -DIN GUIDE TIL MUSIKKEN!</title>
<META NAME="Title" CONTENT="Musikviden.dk -Din guide til musikken!">
<META NAME="Revisit-after" CONTENT="30">
<META NAME="Author" CONTENT="Daniel Beldring">
<LINK REV=made href="mailto:webmaster@musikviden.dk">
<META HTTP-EQUIV="Reply-to" CONTENT="webmaster@musikviden.dk">
<META NAME="Copyright" CONTENT="Copyright Musikviden.dk 1999 - 2002">
<META HTTP-EQUIV="Expires" CONTENT="Mon, 03 Mar 2005 00:00:00 GMT">
<META HTTP-EQUIV="Content-language" CONTENT="dan">
<META NAME="Rating" CONTENT="General">
<META NAME="DC.Contributor" CONTENT="Karberg, Jesper; Lawaetz, Daniel">
<META NAME="DC.Rights" CONTENT="Copyright Musikviden.dk 1999 - 2002">
<META NAME="DC.Identifier" CONTENT="
http://www.musikviden.dk"><META NAME="DC.Publisher" CONTENT="Musikviden.dk">
<META NAME="DC.Date" SCHEME="ISO8601" CONTENT="2000-08-07">
<META NAME="DC.Language" scheme="NISOZ39.50" CONTENT="dan">
<LINK REL="schema.dc" HREF="
http://purl.org/metadata/dublin_core_elements"><META NAME="Generator" CONTENT="Stone's WebWriter 3.5">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="
http://www.musikviden.dk/style.css"><style type="text/css">body {
background-image: URL(cell_head_bg.gif);
background-repeat: no-repeat;
background-attachment: fixed;
background-position: bottom;
}
</style>
</head>
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" bgcolor="#F5FBFF" style="font-family: Verdana">
<table width="705" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="5" align="center"><?php include("
http://www.musikviden.dk/top.php"); ?></td>
</tr>
<TR>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="
http://www.musikviden.dk/billeder/main_celle_bg.gif"><tr>
<td width="10" border="0"></td>
<td valign="top" width="131" border="0"><?php include("
http://www.musikviden.dk/left.php"); ?></td>
<td valign="top" width="423" topmargin="0" align="middle">
<?php
$db=mysql_connect("******","******","*******");
mysql_select_db("musikvidendk",$db);
$foresp=mysql_query("select dato, overskrift, SUBSTRING(tekst,1,300) as tekst, billede, id from nyheder order by id desc limit 0,1");
while($data=mysql_fetch_array($foresp)){
?>
<!-- NYHED 1 -->
<table width="411" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="10"></td>
</TR>
<TR>
<td>
<table border="0" width="411" height="100%" background="
http://www.musikviden.dk/billeder/text_cell_top.gif" cellpadding="0" cellspacing="0">
<TR>
<TD width="206 height="22" valign="top">
<font face="arial" style="font-size: 12px"> <B><?php echo "$data[1]"; ?></B></font>
</td>
<td width="205" height="22" align="right"><font face="arial" style="font-size: 11px">
<a href="
http://www.musikviden.dk/undersider/musiknyhed.php?id=<? echo $data[4]; ?>">Læs Mere...</a>
</td>
</TR>
</table>
</td>
</TR>
<TR>
<td height="133">
<table height="133" width="411" border="0" background="
http://www.musikviden.dk/billeder/text_cell_bottom.jpg" style="background-repeat: no-repeat" cellpadding="0" cellspacing="0">
<TR>
<td width="281" align="center">
<table width="270" height="130" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="110">
<font face="tahoma" style="font-size: 11px"><?php echo "$data[2]"; ?>...</font></td>
</TR>
<TR>
<td height="20">
<font face="tahoma" size="1">
Lagt online d. <? echo date("j/n - Y", $data[0]); ?>
</font>
</td>
</TR>
</table>
</td>
<td width="130" align="center" valign="middle">
<IMG SRC="../billede/<? echo $data[3]; } ?>" BORDER="1" WIDTH="120" height="120" ALT="">
</td>
</tr>
<TR>
<td height="20">
</td>
</tr>
</table>
</td>
</TR>
</table>
<?php
$db=mysql_connect("******","******","******");
mysql_select_db("musikvidendk",$db);
$foresp=mysql_query("select dato, overskrift, SUBSTRING(tekst,1,300) as tekst, billede, id from nyheder order by id desc limit 1,1");
while($data=mysql_fetch_array($foresp)){
?>
<!-- NYHED 2 -->
<table width="411" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="10"></td>
</TR>
<TR>
<td>
<table border="0" width="411" height="100%" background="
http://www.musikviden.dk/billeder/text_cell_top.gif" cellpadding="0" cellspacing="0">
<TR>
<TD width="206 height="22" valign="top">
<font face="arial" style="font-size: 12px"> <B><?php echo "$data[1]"; ?></B></font>
</td>
<td width="205" height="22" align="right"><font face="arial" style="font-size: 11px">
<a href="
http://www.musikviden.dk/undersider/musiknyhed.php?id=<? echo $data[4]; ?>">Læs Mere...</a>
</td>
</TR>
</table>
</td>
</TR>
<TR>
<td height="133">
<table height="133" width="411" border="0" background="
http://www.musikviden.dk/billeder/text_cell_bottom.jpg" style="background-repeat: no-repeat" cellpadding="0" cellspacing="0">
<TR>
<td width="281" align="center">
<table width="270" height="130" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="110">
<font face="tahoma" style="font-size: 11px"><?php echo "$data[2]"; ?>...</font></td>
</TR>
<TR>
<td height="20">
<font face="tahoma" size="1">
Lagt online d. <? echo date("j/n - Y", $data[0]); ?>
</font>
</td>
</TR>
</table>
</td>
<td width="130" align="center" valign="middle">
<IMG SRC="../billede/<? echo $data[3]; } ?>" BORDER="1" WIDTH="120" height="120" ALT="">
</td>
</tr>
</table>
</td>
</TR>
<TR>
<td height="20">
</td>
</tr>
</table>
<!-- Community -->
<table width="411" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="10"></td>
</TR>
<TR>
<td>
<table border="0" width="411" height="100%" background="
http://www.musikviden.dk/billeder/text_cell_top.gif" cellpadding="0" cellspacing="0">
<TR>
<TD width="206 height="22" valign="top">
<font face="verdana" style="font-size: 12px"> <B>Nyt online community!</B></font>
</td>
<td width="205" height="22" align="right"><font face="arial" style="font-size: 11px">
<a href="
http://www.musikviden.dk/community/newuser.php">Opret Bruger</a>
</td>
</TR>
</table>
</td>
</TR>
<TR>
<td height="133">
<table height="133" width="411" border="0" background="
http://www.musikviden.dk/billeder/text_cell_bottom.jpg" style="background-repeat: no-repeat" cellpadding="0" cellspacing="0">
<TR>
<td width="130" align="center" valign="middle">
<IMG SRC="../billede/musik120x120.jpg" BORDER="0" WIDTH="120" height="120" ALT="">
</td>
<td width="281" align="center">
<table width="270" height="130" border="0" cellpadding="0" cellspacing="0">
<TR>
<td height="110">
<font face="tahoma" style="font-size: 10px"><B>Benyt dig af vores community og få følgende fordele:</B><BR><BR>
1) Få tilsendt nyheder med din favorit kunster!<BR>
2) Modtag tilbud på cd'er mm.<BR>
3) Få styr på dine cd'er online!<BR>
4) Få kontakt med andre musikinteresserede!<BR>
5) Køb merchandise til medlemspriser!<BR>
6) Bliv en del af et netværk!</font></td>
</TR>
<TR>
<td height="20">
<font face="tahoma" size="1">
<B>Så tryk "Opret bruger" og se mulighederne.</B>
</font>
</td>
</TR>
</table>
</td>
</tr>
</table>
</td>
</TR>
</table>
</td>
<td valign="top" width="131" border="0"><?php include("
http://www.musikviden.dk/right.php"); ?></td>
<td width="10" border="0"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5" align="center"><?php include("
http://www.musikviden.dk/partnerbund.php"); ?></td>
</tr>
<tr>
<td align="center"><?php include("
http://www.musikviden.dk/bund.php"); ?></td>
</tr>
<tr>
<td height="20">
</td>
</tr>
</table>
</body>
</html>
-------------------------------------------------------------------------
Kan i se nogen loops?
