Insert Error 1136
| From: | David Smith | Date: | Thu, 30 Nov 2000 16:29:16 +0000 |
| Subject: | Insert Error 1136 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-28071@lists.php.net to get a copy of this message | ||
I am new to PHP trying to create an insert only I am getting the followin
error:
1136: Column count doesn't match value count at row 1
Code:
<?php
if ($submit == "click"){
$connection = mysql_connect ("localhost", "*****", "*****");
if ($connection == false){
echo mysql_errno().": ".mysql_error()."<BR>";
exit;
}
$query = "insert into members_db values ('$Username', '$Password',
'$Email', '$FullName', '$Address', '$City',
'$State', '$Zip', '$Phone')";
$result = mysql_db_query ("combat", $query);
if ($result){
echo "You have Successfully Registered!";
}
else{
echo mysql_errno().": ".mysql_error()."<BR>";
}
mysql_close ();
}
else{
echo "
<form method=\"post\" action=\"register.php\">
Enter your Username
<input type=\"text\" name=\"Username\"></input><br>
Enter your password
<input type=\"text\" name=\"Password\"></input><br>
Enter your full name
<input type=\"text\" name=\"FullName\"></input><br>
Enter your email address
<input type=\"text\" name=\"Email\"></input><br>
Enter your address
<input type=\"text\" name=\"Address\"></input><br>
Enter your city
<input type=\"text\" name=\"City\"></input><br>
Enter your state
<input type=\"text\" name=\"State\"></input><br>
Enter your zip
<input type=\"text\" name=\"Zip\"></input><br>
Enter your phone number
<input type=\"text\" name=\"Phone\"></input><br>
<input type=\"submit\" name=\"submit\"
value=\"click\"></input>
</form>
";
}
?>