Hvorfor faar jeg denne fejl
Jeg faar denne fejl 'Key column 'username' doesn't exist in table' naar jeg prøver at sende en forspørgelse til mysql db'en i form af et INSERT (php) Jeg ved ikke hvad der gaar galt.Min kode jeg bruger er:
<?
$new_password = md5($password);
setcookie("coo_username","$username",time()+86400);
setcookie("coo_password","$new_password",time()+86400);
setcookie("coo_passworda","$password",time()+86400);
setcookie("coo_email","$email",time()+86400);
?>
<?
if (!$username || !$new_password || !$email)
{
echo "<font color=\"red\">Username, email and password is required!</font>";
exit();
}
else
{
mysql_connect("localhost", "xx", "xx");
mysql_select_db("xx");
$tjek = mysql_query("SELECT * FROM users WHERE username = '$username'");
if (mysql_num_rows($tjek))
{
echo "<font color=\"red\">Your username already exist</font>";
exit();
}
else
{
addslashes($username);
addslashes($new_password);
addslashes($email);
mysql_connect("localhost", "xx", "xx");
mysql_select_db("xx");
mysql_query("CREATE TABLE wishlist_$username (
subject varchar(255) NOT NULL,
description text NOT NULL,
avatar varchar(255) NOT NULL,
price varchar(255) NOT NULL,
id int(11) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY (id),
UNIQUE username (username, id) )") or die(mysql_error());
$add_profil = mysql_query("INSERT INTO users (username, password, email)" . "VALUES ('$username', '$new_password', '$email')")OR die(mysql_error());
echo "(oprettet)";
}
}
?>
haaber der er nogle der kan hjælpe!!
