No data in Mysql db
Hi guys and gals
I am working on a little project and have run into a snag... All my tables are working fine except 1, I simply cannot get any data into it via my script....
$Nickname = $_REQUEST["Nickname"];
$Realname = $_REQUEST["Realname"];
$Email = $_REQUEST["Email"];
$ICQ = $_REQUEST["ICQ"];
$AIM = $_REQUEST["AIM"];
$Skype = $_REQUEST["Skype"];
$Notes = $_REQUEST["Notes"];
$Force = $_REQUEST["Force"];
mysql_connect("localhost","XXXXX","XXXXX") or die(mysql_error());
mysql_select_db("webmasters") or die(mysql_error());
mysql_query("INSERT INTO Webms(Nick,Real,Email,ICQ,AIM,Skype,Notes,Force)
values('$Nickname','$Realname','$Email','$ICQ','$AIM','$Skype','$Notes','$Force')");
I have tested that I actually do get the data from the form, so that isn't the problem. I have double checked that the table name (and DB name) are correct and they are... The column names are correct aswell... There is 1 more column in the table called ID which is INT and auto_increment. All the other columns are just plain text.
If anybody can tell me what the #¤/&#¤ is wrong here I will be a very happy camper.
Thanks
Xallow
|