Hvorfor smides data ike i db
Hvorfor kommer dataene ikke i db'en ??<?
mysql_connect("localhost","*****","******");
mysql_select_db("*******");
$dato = date("YmdHis");
if (isset($_POST['navn']) && isset($_POST['mail']) && isset($_POST['besked'])){
$insertSQL = "insert into gaestebog (navn, mail, besked)
values ('$_POST[navn]', '$_POST[mail]', '$_POST[besked])";
mysql_query($insertSQL);
$status = 1;
}
switch($status) {
case 1:
echo "Data gemt";
break;
default:
?>
<body>
<p align="center"> </p>
<form name="form1" method="post" action="<? $_SERVER['PHP_SELF'] ?>">
<p align="center">
<input name="navn" type="text" onfocus="if(this.value==this.defaultValue)this.value='';" onblur="if(this.value=='')this.value=this.defaultValue;" value="Navn" maxlength="30">
<input name="mail" type="text" onfocus="if(this.value==this.defaultValue)this.value='';" onblur="if(this.value=='')this.value=this.defaultValue;" value="Mail" maxlength="30">
</p>
<p align="center">
<textarea name="besked" cols="34" rows="5" onfocus="if(this.value==this.defaultValue)this.value='';" onblur="if(this.value=='')this.value=this.defaultValue;">Besked</textarea>
</p>
<p align="center">
<input type="submit" name="Submit" value="Gem">
</p>
</form>
</body>
</html>
<?
break;
}
?>
