<?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;
        case "klar":
$arrow = $fetch['titel'];
if ($_POST['godkann'] == 'vara'){
}
elseif ($_POST['godkann'] == 'godkann'){
$godkannfilm = mysql_query("UPDATE film SET activated='1' WHERE titel='$arrow'")
or die(mysql_error());
echo "Filmen $arrow har nu godkänts och ligger nu uppe på sidan!"; }
elseif ($_POST['godkann'] == 'tabort'){
$tabort = mysql_query("DELETE FROM film WHERE titel='$arrow' LIMIT 1")
or die(mysql_error());
}
break;
}
} ?>