I'm having a problem with a MySQL "INSERT INTO" command. I'm connecting to the database, and some of the data is going, and some is mixed up. Here's the code:
$FName=$POST['FName'];
$LName=$POST['LName'];
$UName=$POST['UName'];
$PWord=$POST['PWord'];
$EMail=$_POST['EMail'];
mysql_connect($host, $user, $pass) or die('Connection died!');
mysql_select_db($db) or die('Selection died!');
$add_all = "INSERT INTO $table (FName, LName, UName, PWord, EMail) VALUES ('$FName','$LName','$UName','$Pword','$EMail')";
mysql_query($add_all) or die(mysql_error());
The problem is that PWord & EMail are blank in the database, and FName contains the EMail value. LName & UName are OK. There is a Primary Key -Indexed & Autonumbered field also.