Untitled

<?php
require("index/mysql.php");
// Menüpontok elkészítése
$sql = "SELECT id, menunev
		FROM fightstar
		WHERE statusz = 'aktiv'
		ORDER BY sorszam ASC";
$eredmeny = mysql_query($sql);

$menu = "";
while ($sor = mysql_fetch_assoc($eredmeny)) {
	$menu .= "<li><a href=\"?id=".$sor['id']."\">".$sor['menunev']."</a></li>\n";
}

// Tartalom elkészítése
$id = (isset($_GET['id'])) ? $_GET['id'] : 1;
$sql = "SELECT menunev, tartalom, datum
		FROM fightstar
		WHERE id = ".$id;
$eredmeny = mysql_query($sql);
$sor = mysql_fetch_assoc($eredmeny);
$tartalom = "<h2>".$sor['menunev']."</h2>
".$sor['tartalom']."
<p>Utolsó frissítés: ".$sor['datum']."</p>\n";

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="hu" xml:lang="hu">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
<title>MyCMS Tartalomkezelő rendszer</title>
<meta name="Description" content="" />
<meta name="Keywords" content="" />
<meta name="Author" content="" />
<meta name="Publisher" content="" />
<meta name="Copyright" content="" />
<meta name="Distributor" content="Global" />
<meta name="Rating" content="General" />
<meta name="Robots" content="Index, follow" />
<meta name="Revisit-After" content="14 days" />
<link href="index/mycms.css" rel="stylesheet" type="text/css" />
<link href="index/favicon.png" rel="icon" type="image/x-icon" />
</head>

<body>
<div id="wrapper">
	<div id="header">
		<h1>MyCMS&reg; Tartalomkezelő rendszer</h1>
	</div>

	<div id="navigation">
		<h2>Menü</h2>
		<ul>
			<?php print $menu; ?>
		</ul>
	</div>

	<div id="content">
		<?php print $tartalom; ?>
	</div>

	<div id="footer">
		<p>&copy; 2010 MyCMS&reg; Tartalomkezelő rendszer</p>
	</div>
</div>
</body>