<?php $filmfix = mysql_query("SELECT * FROM film WHERE activated='0' ORDER BY sent ASC")
or die(mysql_error());

while($fetch = mysql_fetch_array($filmfix)) {
switch ( $_GET['id'] ){
			case "film":
			echo "<form id='form' name='form' method='post' action='godkann.php?id=klar'>";
			echo "<input type='text' name='titel' id='titel' value='".$fetch['titel']."' />";
			echo "<br />";
			echo "<textarea name='info' id='info' cols='45' rows='5'>".$fetch['info']."</textarea>";
			echo "<br />";
			echo "<select name='godkann' id='godkann'>
<option value='vara'>Låt vara</option>
<option value='godkann'>Godkänn</option>
<option value='tabort'>Ta bort</option>
</select>";
echo "<br /><br />";
echo "<input type='submit' name='skicka' id='skicka' value='Validera' />";
echo "</form>";
	break;
}
}
$hanterafilmtitel = $fetch['titel'];
$hanterafilmfix = mysql_query("SELECT * FROM film WHERE titel='$hanterafilmtitel'")
or die(mysql_error());
while($fetch = mysql_fetch_array($hanterafilmfix)) {
switch ( $_GET['id'] ){
		case "klar":
		$hanterafilmtitel = $fetch['titel'];
if ($_POST['godkann'] == 'vara'){
}
elseif ($_POST['godkann'] == 'godkann'){
$godkannfilm = mysql_query("UPDATE film SET activated='1' WHERE titel='$hanterafilmtitel'")
or die(mysql_error());
echo "Filmen $hanterafilmtitel har nu godkänts och ligger nu uppe på sidan!"; }
elseif ($_POST['godkann'] == 'tabort'){
$tabort = mysql_query("DELETE FROM film WHERE titel='$hanterafilmtitel' LIMIT 1")
or die(mysql_error());
}
break;
}
} ?>