connect();
if (!$con) {
die ('I cannot connect to the database because: ' . mysql_error());
}
mysql_select_db($dbMysql->database);
if ("" != $_POST['business_name'])
{
$type = $_POST['business_type'];
switch($type)
{
case "b_b":
$selectType = "Bed & Breakfasts";
break;
case "golf":
$selectType = "Golf Courses";
break;
case "rest":
$selectType = "Restaurants";
break;
case "spas":
$selectType = "Spas";
break;
case "other":
$selectType = "Other";
break;
}
$status = AddPending($_POST, $_FILES, $type);
if ($status)
{
$msg="
New Partner:
Business Name: ".$_POST['business_name']."
Physical Address1: ".$_POST['address_1']."
Physical Address2: ".$_POST['address_2']."
City: ".$_POST['city']."
State: ".$_POST['state']."
ZIP: ".$_POST['zip']."
Country: ".$_POST['country']."
Type of Business: ".$selectType."
Job Title: ".$_POST['job_title']."
First Name: ".$_POST['first_name']."
Last Name: ".$_POST['last_name']."
Phone Number: ".$_POST['phone']."
Fax: ".$_POST['fax']."
Email: ".$_POST['email']."
Web Site: ".$_POST['web_site']."
Comments:
".$_POST['comments']."
";
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: \r\n";
mail('newpartner@giftescapes.com','GiftEscapes.com',$msg,$headers);
header("location: thank-you.html");
die();
}
}
$sqlStates = "select distinct state,state_abbrev from states where state!='' ORDER by state ASC ";
$resStates = mysql_query($sqlStates,$con);
if (isset($_POST['state']))
{
$state = $_POST['state'];
$sqlCities = "select distinct city_region from city_region where state='$state' ORDER by city_region ASC ";
$rCities = mysql_query($sqlCities);
}
mysql_close($con);
?>
Gift Escapes
Do you have any questions that I can help you with?
