1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39:

$query = "SELECT titel, genre, anz, audio, video, id FROM $datatab ORDER BY id";
                $result = @mysql_query($query,$db) or die(mysql_error());
                while ($row = mysql_fetch_row($result))
 
{
		$row[0]=nl2br ($row[0]);
		print "<tr>";
		print "<td>$row[5]</td>";



		print "<td>";
		echo "<SCRIPT LANGUAGE='JavaScript'>n";
		echo "<!--n";
		echo "function Uhr()n";
		echo "{n";
		echo "var win;n";
		echo "win = window.open('$row[5].jpg', 'Uhr','width=500,height=500');n";
		echo "win.document.open('text/html');n";
		echo "win.document.fgColor='#BFBFBF';n";
		echo "win.document.bgColor='#000000';n";
		echo "win.document.write("
<center>Film: $row[0]
Nr.:$row[5]

<IMG SRC='DVD/$row[5].jpg' WIDTH=400 HEIGHT=400 BORDER=0 ALT=''>");n";
		echo "}n";
		echo "//-->n";
		echo "</script>n";
		echo "<A HREF='#' onClick='Uhr()'>$row[0]</a>n";
		echo "</td>n";
		echo "<td>$row[1]</td>n";
		echo "<td>$row[2]</td>n";
		echo "<td align='center'><IMG SRC='$row[3].jpg' BORDER=0 ALT=''></td>n";
		echo "<td align='center'><IMG SRC='$row[4].jpg' BORDER=0 ALT=''></td>n";
		echo "</tr>n";
}