I am getting this error when I submit a form:
Error: Column count doesn't match value count at row 1
THESE ARE MY COLUMNS (IN ORDER) IN MY TABLE CLIENTS:
ClientID
ClientName
ClientBldgName
ClientStNo
ClientStName
ClientDistName
ClientCityName
ClientPostCode
ClientCountry
AreaCode
MainPhone
MainFax
MainEmail
MainContact
Comments
ConsultantID
ClientStType
THIS IS MY RESULTS.PHP PAGE:
<head>
<title>4i dotCom Entry Results</title>
</head>
<body>
<h1>4i dotCom Entry Results</h1>
<?
if (!$ClientName || !$ClientStNo || !$ClientStName || !$ClientPostCode || !$AreaCode || !$MainPhone || !$MainFax || !$MainEmail || !$MainContact || !$Comments || !$ConsultantID)
{
echo "You have not entered all the required details.<br>"
."Please go back and try again.";
exit;
}
$ClientID = addslashes($ClientID);
$ClientName = addslashes($ClientName);
$ClientBldgName = addslashes($ClientBldgName);
$ClientStNo = addslashes($ClientStNo);
$ClientStName = addslashes($ClientStName);
$ClientStType = addslashes($ClientStType);
$ClientDistName = addslashes($ClientDistName);
$ClientCityName = addslashes($ClientCityName);
$ClientPostCode = addslashes($ClientPostCode);
$ClientCountry = addslashes($ClientCountry);
$AreaCode = addslashes($AreaCode);
$MainPhone = doubleval($MainPhone);
$MainFax = doubleval($MainFax);
$MainEmail = addslashes($MainEmail);
$MainContact = addslashes($MainContact);
$Comments = addslashes($Comments);
$MainContact = addslashes($MainContact);
$ConsultantID = doubleval($ConsultantID);
$db = @mysql_pconnect("localhost.localdomain:3306", "root", "password");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("4i_dotCom");
$query = "insert into Clients values ('".$ClientName."', '".$ClientBldgName."', '".$ClientStNo."', '".$ClientStName."', '".$ClientDistName."', '".$ClientCityName."', '".$ClientPostCode."', '".$ClientCountry."', '".$Industry."', '".$AreaCode."', '".$MainPhone."', '".$MainFax."', '".$MainEmail."', '".$MainContact."', '".$Comments."', '".$ConsultantID."', '".ClientStType."')";
$result = mysql_query($query) or die("Error: ".mysql_error());
if ($result)
echo mysql_affected_rows()." client inserted into database.";
?>
</body>
Anyone?
