I have omitted 3 fields ClientStType, ClientDistName and ClientBldgName from the IF statement as I don't won't to be obligated to use them in the form. Yet I still get the error:
You have not entered all the required details.
Please go back and try again.
Anyone know why?
HERE IS THE RESULT.PHP PAGE
<head>
<title>4i dotCom Entry Results</title>
</head>
<body>
<h1>4i dotCom Entry Results</h1>
<?
if (!$ClientID || !$ClientName || !$ClientStNo || !$ClientStName || !$ClientCityName || !$ClientPostCode || !$ClientCountry || !$Industry || !$AreaCode || !$MainPhone || !$MainFax || !$MainEmail || !$MainContact || !$Comments || !$Industry || !$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", "scott", "whistler1");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("4i_dotCom");
$query = "insert into Clients values ('".ClientID."', '".$ClientName."', '".$ClientBldgName."', '".$ClientStNo."', '".$ClientStName."', '".$ClientDistName."', '".$ClientCityName."', '".$ClientPostCode."', '".$ClientCountry."', '".$Industry."', '".$AreaCode."', '".$MainPhone."', '".$MainFax."', '".$MainEmail."', '".$MainContact."', '".$Comments."', '".$ConsultantID."', '".$ClientStType."',)";
$result = mysql_query($query);
if ($result)
echo mysql_affected_rows()." client inserted into database.";
?>
</body>
