multiple checkbox answers

[kpowning]

Can anyone please help!!!! I have been fighting this for 4 days now. The section with the list of checkboxes named: interest[] will only enter in my database table the last checkbox that the user selects. It won't transfer all the checked interests that they select. (only the last). Is there a code that I'm missing or what is the problem. Also, if someone wants to help me on one more thing, the second email string when the form is submitted, sends out 2 emails - one has the information in it and the other is left blank. Any help????????

BELOW IS THE .PHP SCIPT AND THE NEXT POSTING IS THE HTML SCRIPT......>>>>>

<?php require_once('Connections/smarthomes.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "Contact1")) {
  $insertSQL = sprintf("INSERT INTO Contact1 (`Contact By`, `Project Location`, `Project Type`, `Number Of Bedrooms`, `Number Of Bathrooms`, `Square Footage`, `Interested In`, `First Name`, `Last Name`, Address, City, `State`, Zip, `Email Address`, `Home Phone#`, `Personal Info Authorization`, `Alternate Phone#`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['ContactBy'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['ProjectLocation'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Typeofproject'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Bedrooms'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Bathrooms'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Squarefootage'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['interest'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['FirstName'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['LastName'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Address'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['City'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['State'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Zip'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Email'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['HomePhone'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Authorization'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['AlternatePhone'], "int"));

  mysql_select_db($database_smarthomes, $smarthomes);
  $Result1 = mysql_query($insertSQL, $smarthomes) or die(mysql_error());
}
?>

<?php 
mail($Email, "Your Request", "Thank you for submitting your request. You will be contacted within the next 24-48 hours. \r\n
\r\n\r\n\r\n
---------------------------------------------------------------------------------------------------------------------------------
You have recieved this email by submitting a contact form at: [url]http://www.nevadasmarthomes.com[/url]
---------------------------------------------------------------------------------------------------------------------------------\r\n".
"From: [email][e-mail][/email]\r\n".
"Reply-To: [email][e-mail][/email]\r\n".
"Return-Path: [email][e-mail][/email]\r\n");
?>
<?php 
mail("[e-mail]", "Submitted Contact for [url]www.Nevadasmarthomes.com[/url]", "
-----------------------------------------------------------------------------------------------------------
The following is the clients personal information, submitted at [url]http://www.nevadasmarthomes.com:[/url]
-----------------------------------------------------------------------------------------------------------\r\n
First Name: $FirstName\r\n
LastName: $LastName\r\n
Address: $Address\r\n
City: $City,   State: $State,   Zip: $Zip\r\n
Email: $Email\r\n
Home Phone#: $HomePhone\r\n
Alternate Phone#: $AlternatePhone\r\n
Please Contact me by: $ContactBy\r\n
Project Location: $ProjectLocation\r\n
Project Type: $Typeofproject\r\n
My home/office has this many bedrooms: $Bedrooms\r\n
My home/office has this many Bathrooms: $Bathrooms\r\n
My home/office is approximately this many square feet: $Squarefootage\r\n
I'm interested in: $interest\r\n
Authorization of use of personal information: $Authorization\r\n");
?>

😕 😕 😕

[kpowning]

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_validateForm() { //v4.0
var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args);
if (val) { nm=val.name; if ((val=val.value)!="") {
if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
min=test.substring(8,p); max=test.substring(p+1);
if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
} if (errors) alert('The following error(s) occurred:\n'+errors);
document.MM_returnValue = (errors == '');
}
//-->
</script>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" method="POST" name="Contact1" id="Contact1" onSubmit="MM_validateForm('Squarefootage','','RisNum','FirstName','','R','LastName','','R','Email','','RisEmail','Address','','R','City','','R','State','','R','Zip','','RisNum','HomePhone#','','RisNum','Alternatephone#','','NisNum');return document.MM_returnValue">
<div align="center">
<p><em><font size="4">Please use the form below to contact the Nevada Smart
Homes, Inc. staff for estimates, questions, comments, or anything else that
comes to mind.</font></em></p>
<p><u><strong>What kind of communication would you like to send to Nevada
Smart Homes, Inc?</strong></u></p>
<p align="justify">
<label> </label>
</p>
<p align="left">
<label>
<input type="radio" name="ContactBy" value="Please contact me by phone for an estimate">
Please contact me by phone for an estimate</label>
<br>
<label>
<input type="radio" name="ContactBy" value="Please contact me by phone or email to answer questions I have about home automation">
Please contact me by phone or email to answer questions I have about home
automation</label>
<br>
<label>
<input type="radio" name="ContactBy" value="Request for Service / Suggestion / General Comment ">
Request for Service / Suggestion / General Comment</label>
<br>
</p>
<p align="justify"> <br>
</p>
<p><strong><u>Tell us about your home automation project:</u></strong></p>
<p align="justify">This project is at what location:
<select name="ProjectLocation" id="ProjectLocation">
<option value="Home">Home</option>
<option value="Not Home">Not Home</option>
<option value="Steve's House">Steves House</option>
</select>
</p>
<p align="justify">This project is what type:
<select name="Typeofproject" id="Typeofproject">
<option value="New Construction in Planning Stage">New Construction in
Planning Stage</option>
</select>
</p>
<p align="justify">How many bedrooms does your house consist of:
<select name="Bedrooms" id="Bedrooms">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
</select>
</p>
<p align="justify">How many Bathrooms does your house consist of
<select name="Bathrooms" id="Bathrooms">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
</select>
</p>
<p align="justify">My house/office consists of this square footage:
<input name="Squarefootage" type="text" id="Squarefootage" value="Please Enter QTY">
</p>
<p><u><strong>I'm interested in the following home automation area (Please
Select One):</strong></u></p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Total home/office automation">
Total home/office automation</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Lighting / Scene control">
Lighting / Scene control</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="HVAC (Heating &amp; Air Conditioning) Control">
HVAC (Heating &amp; Air Conditioning) Control</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Whole home/office Audio">
Whole home/office Audio</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Home Theater">
Home Theater</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Advanced Irrigation">
Advanced Irrigation</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Enhanced Security Control">
Enhanced Security Control</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Touch-Screen Operation Upgrade">
Touch-Screen Operation Upgrade</p>
<p align="justify">
<input name="interest[]" type="checkbox" id="interest" value="Advance Remote Access (Control via phone and/or internet)">
Advance Remote Access (Control via phone and/or internet)</p>
<p align="center"><strong><u>Customer Information:</u></strong></p>
<p align="justify">First Name
<input name="FirstName" type="text" id="FirstName">
</p>
<p align="justify">Last Name
<input name="LastName" type="text" id="LastName">
</p>
<p align="justify">Email
<input name="Email" type="text" id="Email">
</p>
<p align="justify">Address:
<input name="Address" type="text" id="Address">
</p>
<p align="justify">City
<input name="City" type="text" id="City">
State
<input name="State" type="text" id="State">
Zip
<input name="Zip" type="text" id="Zip">
</p>
<p align="justify">Home Phone#:
<input name="HomePhone" type="text" id="HomePhone">
</p>
<p align="justify">Alternate Phone#:
<input name="AlternatePhone" type="text" id="AlternatePhone">
</p>
<p align="center"><strong><em>I authorize Nevada Smart Homes to give my &quot;Personal
Information&quot; to other automation related businesses for demographic
puposes. </em></strong></p>
<p>
<label>
<input name="Authorization" type="radio" value="Authorized" checked>
Yes</label>
<br>
<label>
<input type="radio" name="Authorization" value="Not Authorized">
No</label>
<br>
</p>
</div>
<div align="center">
<input type="submit" name="Submit" value="Submit">
<input type="submit" name="Submit2" value="Clear Form">
</div>
<div align="center">
<p><em><font size="2">Please be aware. Nevada Smart Homes, Inc. staff will
never share names or personal contact information to other individuals or
businesses.</font></em></p>
</div>

<input type="hidden" name="MM_insert" value="Contact1">

</form>
</body>
</html>