det virker ikke ..
- får denne fejl: Invalid query: Duplicate entry '' for key 2
<?php
include("sql.php");
$username = mysql_escape_string($_POST["username"]);
$navn = mysql_escape_string($_POST["navn"]);
$landsdel = mysql_escape_string($_POST["landsdel"]);
$status = mysql_escape_string($_POST["status"]);
$fod = mysql_escape_string($_POST["fod"]);
$billede = mysql_escape_string($_POST["billede"]);
$hp = mysql_escape_string($_POST["hp"]);
$arto = mysql_escape_string($_POST["arto"]);
$fritekst = mysql_escape_string($_POST["fritekst"]);
$alder = mysql_escape_string($_POST["alder"]);
$ip = mysql_escape_string($_POST["ip"]);
$email = mysql_escape_string($_POST["email"]);
$tid = date("j. M. Y");
mysql_query("INSERT INTO upload_profil(username,navn,landsdel,status,fod,billede,hp,arto,fritekst,alder,email,ip,tid) VALUES ('".$username."','".$navn."','".$landsdel."','".$status."','".$fod."','".$billede."','".$hp."','".$arto."','".$fritekst."','".$alder."','".$email."','".$_SERVER['REMOTE_ADDR']."','".$tid."')") or die("Invalid query: " . mysql_error());
mkdir($username,0777);
header("location: " . $_SERVER["HTTP_REFERER"]);
?>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0">
<tr><td><p align="left">Brugernavn:</td><td><input type="text" name="username" size="29"></td></tr>
<tr><td>Navn:</td><td><input type="text" name="navn" size="29"></td></tr>
<tr><td>Alder:</td><td><input type="text" name="alder" size="29"></td></tr>
<tr><td>By:</td><td><select name="landsdel">
<option value ="ronne">Rønne</option>
<option value ="nexo">Nexø</option>
<option value ="aakirkeby">Aakirkeby</option>
<option value ="hasle">Hasle</option>
<option value ="svnake">Svaneke</option>
<option value ="gudhjem">Gudhjem</option>
<option value ="allinge">Allinge</option>
<option value ="sandvig">Sandvig</option>
<option value ="andet">Andet</option>
</select></td></tr>
<tr><td>Status:</td><td><input type="text" name="status" size="29"></td></tr>
<tr><td>Fødselsdag:</td><td><input type="text" name="fod" value="2006-05-10" size="29"></td></tr>
<tr><td>Billede:</td><td><input type="text" name="billede" size="29"></td></tr>
<tr><td>Hjemmeside:</td><td><input type="text" name="hp" size="29"></td></tr>
<tr><td>Arto:</td><td><input type="text" name="arto" size="29"></td></tr>
<tr><td>Kommentar:</td><td>
<textarea name="fritekst" rows="5" cols="22"></textarea></td></tr>
<tr><td colspan="2">
<p align="center"><input type="submit" value="Opret bruger"></td></tr>
</table>
</form>
</center>
</body>
</html>
