<?php
	include 'mysql.php';
	//Mysql DATA selecteren

	//mysql data weergeven
if(isset($_GET['id']) && is_numeric($_GET['id'])) {
  $query="
		SELECT
			*
		FROM
			films
        WHERE
            id = ".mysql_real_escape_string($_GET['id'])."
		ORDER BY
			titel
	";

	if (!($temp = mysql_query($query,$connection)))
	showerror();
    // BEGIN LOOP
	while ($films = mysql_fetch_array($temp))
	{
?>

<div id="main_l_l">
	<div id="title_bar" class="rounded">
		<?php echo $films['titel']; ?>
	</div>

	<div class="movie_thumb rounded"></div>

	<div id="subbalk" class="rounded">
		<span class="movie_subbalk_text first"><a href="/">Film</a></span>
		<span class="movie_subbalk_text"><a href="/">Nieuws</a></span>
		<span class="movie_subbalk_text"><a href="/">Trailers</a></span>
		<span class="movie_subbalk_text"><a href="/">Screenshots</a></span>
		<span class="movie_subbalk_text"><a href="/">Cast & crew</a></span>
		<span class="movie_subbalk_text"><a href="/">Recensies</a></span>
	</div>

	<div class="movie_content rounded">
		<?php echo $films['content']; ?>
	</div>

	<div id="subbalk" class="rounded">
		Laatste items
	</div>

	<div class="movie_info rounded">
		<div class="movie_info_item">
			<div class="left" style="width: 470px"><strong>Video: </strong><a href="/">Nieuwe trailer</a></div>
			<div class="right" style="width: 100px; text-align: right;">02-11-2010</div>
			<div class="clear"></div>
		</div>
		<div class="movie_info_item">
			<div class="left" style="width: 470px"><strong>Nieuws: </strong><a href="/">Geen vervolg op succesvolle film</a></div>
			<div class="right" style="width: 100px; text-align: right;">02-11-2010</div>
			<div class="clear"></div>
		</div>
		<div class="movie_info_item last">
			<div class="left" style="width: 470px"><strong>Screenshots: </strong><a href="/">10 nieuwe screenshots toegevoegd</a></div>
			<div class="right" style="width: 100px; text-align: right;">02-11-2010</div>
			<div class="clear"></div>
		</div>
	</div>
</div>

<div id="main_r_r">
	<div id="subbalk" class="rounded">
		Informatie
	</div>

	<div class="movie_info rounded" style="margin-bottom: 5px;">
		<div class="movie_info_item">
			<strong>Regie:</strong> <?php echo $films['regie']; ?>
		</div>
		<div class="movie_info_item">
			<strong>Releas:</strong> <?php echo $films['releas']; ?>
		</div>
		<div class="movie_info_item">
			<strong>Genre:</strong> <?php echo $films['genre']; ?>
		</div>
		<div class="movie_info_item">
			<strong>Taal:</strong> <?php echo $films['taal']; ?>
		</div>
		<div class="movie_info_item">
			<strong>Duur:</strong> <?php echo $films['duur']; ?>
		</div>
		<div class="movie_info_item last">
			<strong>Officiële site:</strong> <a href="<?php echo $films['officiele_site']; ?>">Klik</a>
		</div>
	</div>

	<div id="subbalk" class="rounded">
		Waardering
	</div>

	<div class="movie_info rounded">

	</div>
</div>
<div class="clear"></div>
<?php
// EINDE LOOP
} ?>

<?php
} else {
?>

<div id="main_l_l">
	<div id="subbalk" class="rounded">
		Filmarchief
	</div>

	<div class="content1 rounded">
		<div class="center" style="font-weight:bold">
			<a href="/"> Alles </a>
			<a href="/"> A </a>
			<a href="/"> B </a>
			<a href="/"> C </a>
			<a href="/"> D </a>
			<a href="/"> E </a>
			<a href="/"> F </a>
			<a href="/"> G </a>
			<a href="/films/?id=h"> H </a>
			<a href="/"> I </a>
			<a href="/"> J </a>
			<a href="/"> K </a>
			<a href="/"> L </a>
			<a href="/"> M </a>
			<a href="/"> N </a>
			<a href="/"> O </a>
			<a href="/"> P </a>
			<a href="/"> Q </a>
			<a href="/"> R </a>
			<a href="/"> S </a>
			<a href="/films/?letter=t"> T </a>
			<a href="/"> U </a>
			<a href="/"> V </a>
			<a href="/"> W </a>
			<a href="/"> X </a>
			<a href="/"> Y </a>
			<a href="/"> Z </a>
			<a href="/"> # </a>
		</div>
	</div>

	<?php
    $query="
		SELECT
			*
		FROM
			films
		ORDER BY
			titel
	";

	if (!($temp = mysql_query($query,$connection)))
	showerror();
		// BEGIN LOOP
		while ($films = mysql_fetch_array($temp))
		{
	?>
	<div class="content rounded">
		<div class="left">
			<strong><a href="/"><?php echo $films['titel']; ?></a></strong>
		</div>
		<div class="right">
			<?php echo $films['genre']; ?>
		</div>
	<div class="clear"></div>
	</div>
	<?php
	// EINDE LOOP
	} ?>
</div>


<div id="main_r_r">
	<div id="subbalk" class="rounded">
		Populaire films
	</div>

	<div class="content rounded">

	</div>
</div>

<?php
}
?>