*RESOLVED* Why doesnt this script update database?

[JJohnsenDK]

I have this script where i want the text in the dropdown menu to be update to my database when pressed submit. The script works fine if i do a input type="text". But when i use the dropdown the text doesnt update, why?

[code]
<?php
include('mysql_connect.php');
$hent = "SELECT * FROM wof_pl";
$bestgk = mysql_query($hent) or die(mysql_error());
?>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" >
<br />
<select name="d1">
<?php
$hent = "SELECT * FROM wof_pl";
$bestgk = mysql_query($hent) or die(mysql_error());

while ($vis = mysql_fetch_array($bestgk)){
$df = $vis['wof_pl_pos'];

if ($df == "Forsvar"){
?>
<option value="<?php $df = $vis['wof_pl_name']; ?>"><?php $df = $vis['wof_pl_name']; echo $df; ?></option>

<?php
}
}
?>
</select>

<br /><br />
<input type="submit" value="send" name="submit" />
</form>

<?php
if(isset($_POST['submit'])){
$hent = mysql_query("INSERT INTO wof_best SET wof_best_d1 = '".$_POST['d1']."'");
}
?>
[/code]

[trq]

Try some debugging first.

[code=php:0]
$hent = mysql_query("INSERT INTO wof_best SET wof_best_d1 = '".$_POST['d1']."'") or die(mysql_error());
[/code]

[JJohnsenDK]

Well there isnt a error really because the script inserts a blank field into the database, as if there isnt any text in the drop down menu. My quess is how do i update the database with the text or option i select in the dropdown menu?

[trq]

Im not sure what your doing in your option tag but it should be like...

[code]
<option value="<?php echo $vis['wof_pl_name']; ?>"><?php echo $vis['wof_pl_name']; ?></option>
[/code]

[JJohnsenDK]

It works... Thanks alot for your time and help thorpe  ;D