Update via form

Hej,

jeg har et ret irriterende med mit lille "til-at-holde-styr-på-DVD'er" site.

Når jeg under editmovie.php updaterer en film fra databasen og sender den videre til edited.php så sker der ingenting.

Den sender et movieID videre fra editmovie.php til edited.php.
Måske en fejl i min edited.php script?

---------------edited.php---------------------


<?php
require("functions.php");

$title = $_POST["title"];
$movieID = $_POST["movieID"];

mysql_query("UPDATE movies SET title = '$title' WHERE movieID = '$movieID' ");

mysql_close();

?> 


------------------editmovie.php---------------

<?php
require("functions.php");

$result = mysql_query("SELECT * FROM movies WHERE movieID = ". $_GET["movieID"] ." ");
    while ($row = mysql_fetch_array($result)) {
?>
       
        <form action="edited.php?movieID=<?php echo $row['movieID']; ?>" method="post">
       
        <table class="mainTable">
       
        <tr>
        <td class="tableTopBottom" colspan="2"><b>Edit: <?php echo $row['title']; ?></b></td>
        </tr>
   
        </tr>
        <td class="mainContentTable" colspan="2"><b>Title:</b> <?php echo $row['title']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable"><input type="text" name="title" class="input" /></td>
        </tr>
       
        </tr>
        <td class="mainContentTable" colspan="2"><b>Director:</b> <?php echo $row['director']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable"><input type="text" name="title" class="input" /></td>
        </tr>
       
        </tr>
        <td class="mainContentTable" colspan="2"><b>Actors:</b> <?php echo $row['actors']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable"><input type="text" name="title" class="input" /></td>
        </tr>
       
        </tr>
        <td class="mainContentTable" colspan="2"><b>Year:</b> <?php echo $row['year']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable">

<select name="year">
<?php
for($i = 1900; $i <= 2005; $i++){
echo "<option value='".$i."'>".$i."</option>";
}
?>
</select>
       
        </td>
        </tr>
       
        </tr>
        <td class="mainContentTable" colspan="2"><b>Genre:</b> <?php echo $row['genre']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable"><input type="text" name="genre" class="input" /></td>
        </tr>           

        </tr>
        <td class="mainContentTable" colspan="2"><b>IMDbLink:</b> <?php echo $row['imdblink']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable"><input type="text" name="imdblink" class="input" /></td>
        </tr>

        </tr>
        <td class="mainContentTable" colspan="2"><b>Format:</b> <?php echo $row['format']; ?></td>
        </tr>
   
        <tr>
        <td colspan="2" class="mainContentTable">

<select name="format">
<?php


    $result = mysql_query("SELECT * FROM format");
        while ($row = mysql_fetch_array($result)) {
            echo "<option>$row[format]</option>";
    }
?>

<?php
}

mysql_close();
?>

</select>

</td>
</tr>
</table>

<br />
<input type="submit" name="submit" value="Edit movie" class="input" />
</form>           
----------------------------------------------------

Håber nogle kan hjælpe