<?
$mysql_object = new mysql_db();
$results = $mysql_object->mysql_db_query("SELECT id, title, letter, sprache, kino, fsk, film_bewertung, speed_bewertung, bild, text, genere, hits, DATE_FORMAT(datum,'%d.%m.%Y') AS datum, DATE_FORMAT(datum,'%H:%i:%s') AS datum_klein FROM filme WHERE id='$id'");
while ($resultset = mysql_fetch_object($results)) {
$title = $resultset->title;
$letter = $resultset->letter;
$sprache = $resultset->sprache;
$id = $resultset->id;
$bild = $resultset->bild;
$text = $resultset->text;
$hits = $resultset->hits;
$genere = $resultset->genere;
$datum = $resultset->datum;
$datum_klein = $resultset->datum_klein;
$kino = $resultset->kino;
$fsk = $resultset->fsk;
$film_bewertung = $resultset->film_bewertung;
$speed_bewertung = $resultset->speed_bewertung;
$results2 = $mysql_object->mysql_db_query("UPDATE filme SET hits=$hits+1 WHERE id='$id'");
?><html>
<head>
<SCRIPT language="JavaScript1.2" src="main.js" type="text/javascript"></SCRIPT>
<title> Filmname</title>
<meta name="GENERATOR" content="Namo WebEditor v5.0">
<meta name="description" content="Fügt eine leere Dokumentvorlage ohne definierten Stil ein.">
</head>
<body>
<DIV id="TipLayer" style="width:200px; height:200px; position:absolute; left:50px; top:-100px; z-index:1000; visibility:hidden;">
<p> </p>
</DIV>
<table border="1" width="100%">
<tr>
<td width="973" height="24" colspan="2">
<? echo $title; ?>
</td>
</tr>
<tr>
<td width="104" height="119">
<center><img src="<? echo $bild; ?>" width="81" height="114" border="0"></center> </td>
<td width="863" height="119">
<center><textarea name="formtextarea1" rows="7" cols="53"><? echo $text; ?></textarea></center>
</td>
</tr>
</table>
<font size="1" face="Verdana"><br>
</font><table border="1" width="100%">
<tr>
<td width="973" height="11" colspan="2">
Details
</td>
</tr>
<tr>
<td width="491" height="21">
<table border="1" width="97%">
<tr>
<td width="466" height="15" colspan="2">
Genere:<? echo $genere; ?>
</td>
</tr>
<tr>
<td width="466" height="17" colspan="2">
<p>Sprache:<? echo $sprache; ?></p>
</td>
</tr>
<tr>
<td width="466" height="21" colspan="2">
<p>Hits:<? echo $hits; ?></p>
</td>
</tr>
<tr>
<td width="48%" height="12">
<p>Kommentare: <a href="index.php?section=comment&id=<? echo $id; ?>">lesen</a></p>
</td>
<td width="233" height="12">
<p>Film Bewertung:</p>
</td>
</tr>
</table>
</td>
<td width="476" height="21">
<div align="right">
<table border="1" width="97%">
<tr>
<td width="973" height="12" align="left">
Eingetragen am:<? echo $datum; ?>
</td>
</tr>
<tr>
<td width="973" height="13" align="left">
<p>Eingetragen um:<? echo $datum_klein; ?></p>
</td>
</tr>
<tr>
<td width="973" height="19" align="left">
<p>Kinostart:<? echo $kino; ?></p>
</td>
</tr>
<tr>
<td width="973" height="15" align="left">
<p>FSK:<? echo $fsk; ?></p>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<?
}
?>
</body>
</html>