Create("churchil_demo");
if ($AddAuctioneer == "Yes") {
/* First check to make sure the user has included all
* of the required variables. If not, gripe about it
* and return them a page with the existing info filled
* out already.
*/
$error = 0;
$error += RequiredVar("Name",$Name);
$error += RequiredVar("Address",$Addr1);
$error += RequiredVar("City",$City);
$error += RequiredVar("State",$State);
$error += RequiredVar("Zipcde",$ZipCode);
$error += RequiredVar("Phone1",$Phone1);
if ($error == 0) {
$date = strftime("%Y-%m-%d",time());
$insert = "insert into Auctioneers values (0,'" .
AddSlashes($Name) . "', '" .
AddSlashes($Addr1) . "', '" .
AddSlashes($Addr2) . "', '" .
AddSlashes($Addr3) . "', '" .
AddSlashes($City) . "', '$State', '$ZipCode', '$Phone1'," .
"'$Phone2', '$Fax1', '$Fax2', '" . AddSlashes($Email) . "', '" .
AddSlashes($Website) . "', '" . AddSlashes($Notes) . "', '$date')";
$sql->Insert($insert);
echo("
\n");
echo("
Created new Auctioneer: $Name\n");
echo("
\n");
echo("\n");
/* Clear the values so that they don't appear
* in the next Add form. If these variables
* are not cleared (i.e. there were errors) then the
* previously entered values will reappear in the form
* so that the user doesn't need to reenter them.
*/
$Name = "";
$Addr1 = "";
$Addr2 = "";
$Addr3 = "";
$City = "";
$State = "";
$ZipCode = "";
$Phone1 = "";
$Phone2 = "";
$Fax1 = "";
$Fax2 = "";
$Email = "";
$Website = "";
$Notes = "";
}
}
?>