Unexpected T_STRING. CS4

Report · Dec 17, 2009

I need some help. I keep getting the following "Parse error:syntax error, unexpected T_STRING in home/pearcep/public_html/Content/Untitled-2.php on line 141. I bolded the line in red. I cannot figure out what i have done wrong. Any help would be appreciated. STILL learning. Patty

<?php require_once('../Connections/VendorRegistration.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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;
}
}if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO Results (`date`, Name, Address, City, `State`, Zip, Contact, Phone, Fax, Email, Website, CISV, `HUB or MWBE`, `AC Filters`, `Alarm Monitoring Service`, `Armored Car Service`, `Art Supplies`, `Asbestos Abatement`, `Athletic Supplies & Equipment`, `Auctioneering Services`, `AV Equipment`, `Awards & Trophies`, `Band Uniforms`, `Bulbs & Lamps`, `Campus & Departmental Apparel`, `Campus Promotional Products`, `Carpentry Supplies & Equipment`, `Carpet Replacement & Repair`, `Catering & Groceries`, `Charter Buses & Rental Vehicles`, `Child Care Services`, `Clinic & Trainer Supplies`, `Coffee Service`, `Computer Systems`, `Concrete & Asphalt`, `Dental Insurance Plan`, `Door Installation & Hardware`, `Drill Team Uniforms`, `Food Service Produce`, `Food Service Commodity Processing`, `Food Service Dish Machine Cleaning Supplies`, `Food Service Frozen & Dry Groceries`, `Food Service Kitchen Equip. Maintenance`, `Food Service Kitchen Vent-A-Hood Service`, `Football Field Renovations`, `Ford Trucks and Vans`, `General Supplies`, `Glass & Glass Repair`, `Grease Traps`, `HVAC Services`, `HVAC Supplies & Equipment`, `Intercom & Sound Systems`, `Kitchen Equipment`, `Language Arts Materials`, Letter Jackets`, `Library Furniture`, `Library Media`, Libary Periodicals`, Life Vision EAP Insurance Plans`, `Locksmith Supplies & Equipment`, `Miscellaneous Crafts & Trades`, `Miscellaneous Maintenance Supplies`, `Network Infrastructure Upgrade`, `Office Supplies`, `Paint Services`, `Paint Supplies ? Equipment`, `Paperback & Hardback Books`, `Piano Tuning Repair Moving`, `Plumbing Services`, `Plumbing Supplies & Equipment`, `Portable Building Relocation`, `Printer Cartridges & Related Supplies`, `Printing Services`, `Property $ Casualty Insurance`, `Retail Electric Provider`, `Same Day Copy Service`, `School Agendas and Planners`, `School Furniture & Equipment`, `Science Supplies`, `Solid Waste Recycling`, `Specific Aggregate Stop Loss Insurance`, `Student Athletic Voluntary Accident Insurance`, `Student Incentives`, `Supplemental Voluntary Insurance`, `TAKS_Exam_Preparation_Material`, `Travel Service`, `Two Way Radios`, `Uniforms`, `Worker Compensation`, ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['date'], "text"),
                       GetSQLValueString($_POST['Name'], "text"),
                       GetSQLValueString($_POST['Address'], "text"),
                       GetSQLValueString($_POST['City'], "text"),
                       GetSQLValueString($_POST['State'], "text"),
                       GetSQLValueString($_POST['Zip'], "text"),
                       GetSQLValueString($_POST['Contact'], "text"),
                       GetSQLValueString($_POST['Phone'], "text"),
                       GetSQLValueString($_POST['Fax'], "text"),
                       GetSQLValueString($_POST['Email'], "text"),
                       GetSQLValueString($_POST['Website'], "text"),
                       GetSQLValueString($_POST['radio'], "text"),
                       GetSQLValueString($_POST['RadioGroup1'], "text"),
                       GetSQLValueString(isset($_POST['AC_Filters']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Alarm_Monitoring_Service']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Armored_Car_Service']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['AC_Filters']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Asbestos_Abatement']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Athletic_Supplies_&_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Auctioneering_Services']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['AV_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Awards_&_Trophies']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Band_Uniforms']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Bulbs_&_Lamps']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Campus_&_Departmental_Apparel']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Campus_Promotional_Products']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Carpentry_Supplies_&_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Carpet_Replacement_&_Repair']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Catering_&_Groceries']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Charter_Buses_&_Rental_Vehicles']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Child_Care_Services']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Clinic_&_Trainer_Supplies']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Coffee_Service']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Coffee_Service']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Concrete_&_Asphalt']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Dental_Insurance_Plan']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Door_Installation_&_Hardware']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Drill_Team_Uniforms']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Produce']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Commodity_Processing']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Dish_Machine_Cleaning_Supplies']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Frozen_&_Dry_Groceries']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Kitchen_Equip._Maintenance']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Food_Service_Kitchen_Vent-A-Hood_Service']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Football_Field_Renovations']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Ford_Trucks_and_Vans']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['General_Supplies']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Glass_&Glass Repair']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Grease_Traps']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['HVAC_Services']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['HVAC_Supplies_&_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Intercom_&_Sound_Systems']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Kitchen_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Language_Arts_Materials']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Office_Supplies']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Portable_Building_Relocation']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Printing_Services']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Retail_Electric_Provider']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Same_Day_Copy_Service']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['School_Agendas_and_Planners']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['School_Furniture_&_Equipment']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Science_Suppies']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Solid_Waste_Recycling']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Specific_&_Aggregate_Stop_Loss_ Insurance']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Student_Athletic_&_Voluntary_Accident_Insurance']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Science_Incentives']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Supplemental_Voluntary_Insurance']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['TAKS_Exam_Preparation_Material']) ? "true" : "", "defined","'Y'","'N'"),
        GetSQLValueString(isset($_POST['Uniforms']) ? "true" : "", "defined","'Y'","'N'",
                       GetSQLValueString(isset($_POST['Workers_Compensation']) ? "true" : "", "defined","'Y'","'N'"))

mysql_select_db($database_VendorRegistration, $VendorRegistration);
$Result1 = mysql_query($insertSQL, $VendorRegistration) or die(mysql_error());
$insertGoTo = "../Default.htm";
if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_VendorRegistration, $VendorRegistration);
$query_Recordset2 = "SELECT * FROM Results";
$Recordset2 = mysql_query($query_Recordset2, $VendorRegistration) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);mysql_select_db($database_VendorRegistration, $VendorRegistration);
$query_Recordset2 = "SELECT * FROM Results";
$Recordset2 = mysql_query($query_Recordset2, $VendorRegistration) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

$query_Recordse2 = "SELECT * FROM Results";
$Recordse2 = mysql_query($query_Recordse2, $VendorRegistration) or die(mysql_error());
$row_Recordse2 = mysql_fetch_assoc($Recordse2);
$totalRows_Recordse2 = mysql_num_rows($Recordse2);

$query_Recordset2 = "SELECT * FROM Results";
$Recordset2 = mysql_query($query_Recordset2, $VendorRegistration) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$query_Recordset2 = "SELECT * FROM Results";
$Recordset2 = mysql_query($query_Recordset2, $VendorRegistration) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$query_Recordset2 = "SELECT * FROM Results";
$Recordset2 = mysql_query($query_Recordset2, $VendorRegistration) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">

</style>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" id="form1" name="form1" method="POST">
<div align="left">
    <table width="1085" height="1537" border="0" cellpadding="2" cellspacing="2">
    <td width="1051" height="1525"> <table width="1049" height="195" border="0" cellpadding="2" cellspacing="2"><td width="1015" height="28"><table width="1032" height="1391" border="0" cellpadding="2" cellspacing="2">
<td width="307"><div align="right" class="font">Date </div></td>
    <td width="354"><div align="left">
      <input type="text" name="date" id="date" size="30" />
    </div></td>
    <td width="328" colspan="2" rowspan="14"> </td>
</tr>
<tr>
    <td><div align="right">Vendor Name</div></td>
    <td><label> </label>
      <div align="left">
        <input name="Name" type="text" id="Name" size="50" />
      </div></td>
</tr>
<tr>
    <td><div align="right">Mailing Address</div></td>
    <td><div align="left">
      <label>
        <input name="Address" type="text" id="Address" size="50" />
      </label>
    </div></td>
</tr>
<tr>
    <td><div align="right">City</div></td>
    <td><label> </label>
      <div align="left">
        <input name="City" type="text" id="City" size="50" />
      </div></td>
</tr>
<tr>
    <td><div align="right">State</div></td>
    <td><div align="left">
      <input type="text" name="State" id="State" />
    </div></td>
</tr>
<tr>
    <td><div align="right">Zip</div></td>
    <td><div align="right">
      <label> </label>
      <div align="left">
        <input type="text" name="Zip" id="Zip" />
      </div>
    </div></td>
</tr>
<tr>
    <td><div align="right">Contact for Bids</div></td>
    <td><div align="right">
      <label> </label>
      <div align="left">
        <input name="Contact" type="text" id="Contact" size="30" />
      </div>
    </div></td>
</tr>
<tr>
    <td><div align="right">Phone</div></td>
    <td><div align="left">
      <input type="text" name="Phone" id="Phone" />
    </div></td>
</tr>
<tr>
    <td><div align="right">Email</div></td>
    <td><div align="right">
      <label> </label>
      <div align="left">
        <input type="text" name="Email" id="Email" />
      </div>
    </div></td>
</tr>
<tr>
    <td><div align="right">Fax</div></td>
    <td><div align="left">
      <input type="text" name="Fax" id="Fax" />
    </div></td>
</tr>
<tr>
    <td><div align="right">Website</div></td>
    <td><div align="left">
      <input type="text" name="Website" id="Website" />
    </div></td>
</tr>
<tr>
    <td><div align="right"><br />
      Please select if applicable to your company<br />
      <br />
    </div></td>
    <td><div align="right"></div></td>
</tr>
<tr>
    <td><div align="right">State of Texas CISV<br />
      (Catalog Information Systems Vendor)</div></td>
    <td><div align="right">
      <label> </label>
      <div align="left">
        <input type="radio" name="radio" id="yes" value="yes" />
        Yes</div>
    </div></td>
</tr>
<tr>
    <td><div align="right">HUB or MWBE</div></td>
    <td><div align="left">
      <input type="radio" name="RadioGroup1" value="HUB" id="RadioGroup1_0" />
      <label>HUB</label>
    </div>
      <label> </label>
      <div align="left">
        <input type="radio" name="RadioGroup1" value="MWBE" id="RadioGroup1_1" />
        MWBE</div>
      <div align="left"></div></td>
</tr>
<tr>
    <td colspan="3"><p align="left" class="MsoNormal"><br />
    </p></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="AC_Filters" id="AC_Filters" />
        <span class="font">AC Filters</span></div></td>
    <td><label>
      <input type="checkbox" name="Fine_Arts_Supplies_&_Equipment" id="Fine_Arts_Supplies_&_Equipment" />
    </label>
      Fine Arts Supplies & Equipment
      <p align="left" class="MsoNormal">
      <label>
        <div align="left">
      </label></td>
    <td><label>
      <input type="checkbox" name="Network_Infrastructure_Upgrades" id="Network_Infrastructure_Upgrades" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Network Infrastructure Upgrades</span></label></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Alarm_Monitoring_Service" id="Alarm_Monitoring_Service" />
        <span class="font">        Alarm Monitoring Service</span></div></td>
    <td><p>
      <label>
        <input type="checkbox" name="Fire_Protection_&_Security_Systems" id="Fire_Protection_&_Security_Systems" />
      </label>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Fire Protection & Security Systems</span></p></td>
    <td><label>
      <input type="checkbox" name="Office_Supplies" id="Office_Supplies" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Office Supplies</span></label></td>
</tr>
<tr>
    <td height="25" class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Art_Supplies" id="Art_Supplies" />
        <span class="font">Art Supplies</span></div></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Produce" id="Food_Service_-_Produce" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Food Service - Produce</span></label></td>
    <td><label>
      <input type="checkbox" name="Paint_Services" id="Paint_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Paint Services</span></label></td>
</tr>
<tr>
    <td height="25" class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Armored_Car_Service" id="Armored_Car_Service" />
        <span class="font">        Armored Car Sevice</span></div></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Commodity_Processing" id="Food_Service_-_Commodity_Processing" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Food Service - Commodity Processing</span></label></td>
    <td><label>
      <input type="checkbox" name="Paint_Supplies_&_Equipment" id="Paint_Supplies_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Paint Supplies & Equipment</span></label></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Asbestos_Abatement" id="Asbestos_Abatement" />
        <span class="font">        Asbestos Abatement</span></div></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Dish_Machine_Cleaning_Supplies" id="Food_Service_-_Dish_Machine_Cleaning_Supplies" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Food Service - Dish Machine Cleaning Supplies</span></label></td>
    <td><label>
      <input type="checkbox" name="Paperback_&_Hardback_Books" id="Paperback_&_Hardback_Books" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Paperback & Hardback Books</span></label></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
<input type="checkbox" name="Athletic_Supplies_&_Equipment" id="Athletic_Supplies_&_Equipment" />
        <span class="font">        Athletic Supplies & Equipment</span></div></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Frozen_&_Dry_Groceries" id="Food_Service_-_Frozen_&_Dry_Groceries" />
    Food Service - Frozen & Dry Groceries</label></td>
    <td><label>
      <input type="checkbox" name="Piano_Tuning,_Repair_&_Moving" id="Piano_Tuning,_Repair_&_Moving" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Piano Tuning, Repair & Moving</span></label></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Auctioneering_Services" id="Auctioneering_Services" />
        <span class="font">Auctioneering Services</span></div></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Kitchen_Equip._Maintenance" id="Food_Service_-_Kitchen_Equip._Maintenance" />
      <span class="font">Food Service - Food Service - Kitchen Equip. Maintenance</span></label></td>
    <td><label>
      <input type="checkbox" name="Plumbing_Services" id="Plumbing_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Plumbing Services</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="AV_Equipment" id="AV_Equipment" />
      <span class="font">    AV Equipment</span></label></td>
    <td><label>
      <input type="checkbox" name="Food_Service_-_Kitchen_Vent-A-Hood_Service" id="Food_Service_-_Kitchen_Vent-A-Hood Service" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Food Service - Kitchen Vent-A-Hood Service</span></label></td>
    <td><label>
      <input type="checkbox" name="Plumbing_Supplies_&_Equipment" id="Plumbing_Supplies_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Plumbing Supplies & Equipment</span></label></td>
</tr>
<tr>
    <td class="font"><label> </label>
      <div align="left">
        <input type="checkbox" name="Awards_&_Trophies" id="Awards_&_Trophies" />
        <span class="font">Awards & Trophies</span></div></td>
    <td><label>
      <input type="checkbox" name="Football_Field_Renovations" id="Football_Field_Renovations" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Football Field Renovations</span></label></td>
    <td><label>
      <input type="checkbox" name="Portable_Building_Relocation" id="Portable_Building_Relocation" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Portable</span><span style="font-family:'Times New Roman'; font-size:12.0pt; "> Building</span><span style="font-family:'Times New Roman'; font-size:12.0pt; "> Relocation</span></label></td>
</tr>
<tr>
    <td class="font"><div align="left">
      <input type="checkbox" name="Band_Uniforms" id="Band_Uniforms" />
      <span class="font">Band Uniforms</span></div></td>
    <td><label>
      <input type="checkbox" name="Ford_Trucks_and_Vans" id="Ford_Trucks_and_Vans" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Ford Trucks and Vans</span></label></td>
    <td><label>
      <input type="checkbox" name="Printer_Cartridges_&_Related_Supplies" id="Printer_Cartridges_&_Related_Supplies" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Printer Cartridges & Related Supplies</span></label></td>
</tr>
<tr>
    <td class="font"><div align="left">
      <input type="checkbox" name="Bulbs_&_Lamps" id="Bulbs_&_Lamps" />
      <span class="font">Bulbs & Lamps</span></div></td>
    <td><label>
      <input type="checkbox" name="General_Supplies" id="General_Supplies" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">General Supplies</span></label></td>
    <td><label>
      <input type="checkbox" name="Printing_Services" id="Printing_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Printing Services</span></label></td>
</tr>
<tr>
    <td class="font"><div align="left">
      <input type="checkbox" name="Campus_&_Departmental_Apparel" id="Campus_&_Departmental_Apparel" />
      <span class="font">Campus & Departmental Apparel</span></div></td>
    <td><label>
      <input type="checkbox" name="Glass_&_Glass_Repair" id="Glass_&_Glass_Repair" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Glass & Glass Repair</span></label></td>
    <td><label>
      <input type="checkbox" name="Property_&_Casualty_Insurance" id="Property_&_Casualty_Insurance" />
      <span class="font">Property & Casualty Insurance</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Campus_Promotional_Products" id="Campus_Promotional_Products" />
      <span class="font">Campus Promotional Products</span></label></td>
    <td><label>
      <input type="checkbox" name="Grease_Traps" id="Grease_Traps" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Grease Traps</span></label></td>
    <td><label>
      <input type="checkbox" name="Retail_Electric_Provider" id="Retail_Electric_Provider" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Retail Electric Provider</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Carpentry_Supplies_&_Equipment" id="Carpentry_Supplies_&_Equipment" />
      <span class="times">Carpentry Supplies & Equipment </span></label></td>
    <td><label>
      <input type="checkbox" name="Grounds_Contract_Services" id="Grounds_Contract_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Grounds Contract Services</span></label></td>
    <td><label>
      <input type="checkbox" name="Same_Day_Copy_Service" id="Same_Day_Copy_Service" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Same Day Copy Service</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Carpet_Replacement_&_Repair" id="Carpet_Replacement_&_Repair" />
      <span class="font">Carpet Replacement & Repair</span></label></td>
    <td><label>
      <input type="checkbox" name="Grounds_Supplies_&_Equipment " id="Grounds_Supplies_&_Equipment " />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Grounds Supplies & Equipment </span></label></td>
    <td><label>
      <input type="checkbox" name="School_Agendas_and_Planners" id="School_Agendas_and_Planners" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">School Agendas and Planners</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Catering_&_Groceries" id="Catering_&_Groceries" />
      <span class="font" style="font-family:'Times New Roman'; font-size:12.0pt; ">Catering & Groceries</span></label></td>
    <td><label>
      <input type="checkbox" name="HVAC_Services" id="HVAC_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">HVAC Services</span></label></td>
    <td><label>
      <input type="checkbox" name="School_Furniture_&_Equipment" id="School_Furniture_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">School Furniture & Equipment</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Charter_Buses_&_Rental_Vehicles" id="Charter_Buses_&_Rental_Vehicles" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Charter Buses & Rental Vehicles</span></label></td>
    <td><label>
      <input type="checkbox" name="HVAC_Supplies_&_Equipment" id="HVAC_Supplies_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">HVAC Supplies & Equipment</span></label></td>
    <td><label>
      <input type="checkbox" name="Science_Supplies" id="Science_Supplies" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Science Supplies</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Child_Care_Services" id="Child_Care_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Child Care Services</span></label></td>
    <td><label>
      <input type="checkbox" name="Intercom_&_Sound_Systems" id="Intercom_&_Sound_Systems" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Intercom & Sound Systems</span></label></td>
    <td><label>
      <input type="checkbox" name="Solid_Waste_Recycling" id="Solid_Waste_Recycling" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Solid Waste Recycling</span></label></td>
</tr>
<tr>
    <td class="font"><input type="checkbox" name="Clinic_&_Trainer_Supplies" id="Clinic_&_Trainer_Supplies" /> <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Clinic & Trainer Supplies</span></td>
    <td><label>
      <input type="checkbox" name="Language_Arts_Materials" id="Language_Arts_Materials" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Language Arts Materials</span></label></td>
    <td><label>
      <input type="checkbox" name="Specific_&_Aggregate_Stop_Loss_Insurance" id="Specific_&_Aggregate_Stop_Loss_Insurance" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Specific & Aggregate Stop Loss Insurance</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Coffee_Service" id="Coffee_Service" />
      Coffee Service</label></td>
    <td><label>
      <input type="checkbox" name="Letter_Jackets" id="Letter_Jackets" />
      <span class="font">Letter Jackets</span></label></td>
    <td><label>
      <input type="checkbox" name="Student_Athletic_&_Voluntary_Accident_Insurance" id="Student_Athletic_&_Voluntary_Accident Insurance" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Student Athletic & Voluntary Accident Insurance</span></label></td>
</tr>
<tr>
    <td class="font"><input type="checkbox" name="Computer_Systems" id="Computer_Systems" /> <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Computer Systems</span></td>
    <td><label>
      <input type="checkbox" name="Library_Furniture" id="Library_Furniture" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Library Furniture</span></label></td>
    <td><label>
      <input type="checkbox" name="Student_Incentives" id="Student_Incentives" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Student Incentives</span></label></td>
</tr>
<tr>
    <td class="font"><input type="checkbox" name="Concrete_&_Asphalt" id="Concrete_&_Asphalt" /> <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Concrete & Asphalt</span></td>
    <td><label>
      <input type="checkbox" name="Library_Media" id="Library_Media" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Library Media</span></label></td>
    <td><label>
      <input type="checkbox" name="Supplemental_Voluntary_Insurance" id="Supplemental_Voluntary_Insurance" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Supplemental Voluntary Insurance</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Copier_Service" id="Copier_Service" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Copier Service</span></label></td>
    <td><label>
      <input type="checkbox" name="Library_Periodicals" id="Library_Periodicals" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Library Periodicals</span></label></td>
    <td><label>
      <input type="checkbox" name="TAKS_Exam_Preparation_Material" id="TAKS_Exam_Preparation_Material" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">TAKS Exam Preparation Material</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Custodial_Supplies_&_Equipment" id="Custodial_Supplies_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Custodial Supplies & Equipment</span></label></td>
    <td><label>
      <input type="checkbox" name="Life,_Vision,_&_EAP_Insurance_Plans" id="Life,_Vision,_&_EAP_Insurance_Plans" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Life, Vision, & EAP Insurance Plans</span></label></td>
    <td><label>
      <input type="checkbox" name="Travel_Services" id="Travel_Services" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Travel Services</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Dental_Insurance_Plan" id="Dental_Insurance_Plan" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Dental Insurance Plan</span></label></td>
    <td><label>
      <input type="checkbox" name="Locksmith_Supplies_&_Equipment" id="Locksmith_Supplies_&_Equipment" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Locksmith Supplies & Equipment</span></label></td>
    <td><label>
      <input type="checkbox" name="Two_Way_Radios" id="Two_Way_Radios"/>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Two Way Radios</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Depository_Services" id="Depository_Services"/>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Depository Services</span></label></td>
    <td><label>
      <input type="checkbox" name="Miscellaneous_Crafts_&_Trades" id="Miscellaneous_Crafts_&_Trades"/>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Miscellaneous</span> Crafts & Trades</label></td>
    <td><label>
      <input type="checkbox" name="Uniforms" id="Uniforms" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Uniforms</span></label></td>
</tr>
<tr>
    <td class="font"><input type="checkbox" name="Door_Installation_&_Hardware" id="Door_Installation_&_Hardware"/>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Door Installation & Hardware</span></td>
    <td><label>
      <input type="checkbox" name="Miscellaneous_Maintenance_Supplies" id="Miscellaneous_Maintenance_Supplies"/>
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Miscellaneous Maintenance Supplies</span></label></td>
    <td><label>
      <input type="checkbox" name="Workers_Compensation" id="Workers_Compensation" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Workers Compensation (TPA & Stop Loss)</span></label></td>
</tr>
<tr>
    <td class="font"><label>
      <input type="checkbox" name="Drill_Team_Uniforms" id="Drill_Team_Uniforms" />
      <span style="font-family:'Times New Roman'; font-size:12.0pt; ">Drill Team Uniforms</span></label></td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td class="font"> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td> </td>
    <td> </td>
</tr>
<tr>
    <td> </td>
</tr>
<td> </td>
    <td> </td>
</tr>
<tr>
    <td> </td>
</tr>
<tr></tr>
</table></td>
</tr>
<tr>
    <td colspan="3"><label>
      <input type="submit" name="submit" id="submit" value="Submit" />
    </label></td>
    </tr>
      </table>
    </table>
</div>
<input type="hidden" name="MM_insert" value="form1" />
</form>
</body>
</html>
<?php
mysql_free_result($Recordset2);
?>

Report · Dec 18, 2009

The semicolon is missing from the end of the previous line.

Report · Dec 18, 2009

I had deleted it because I kept getting Parse error: syntax error, unexpected ';' on that line.

Report · Dec 18, 2009

txpattycake wrote:
I had deleted it because I kept getting Parse error: syntax error, unexpected ';' on that line.

That doesn't mean the semicolon is wrong. It means there's something missing before the semicolon (that's why it's "unexpected").

The error is actually at the end of line 138. The closing parenthesis is missing just before the comma at the end of the line:

GetSQLValueString(isset($_POST['Uniforms']) ? "true" : "", "defined","'Y'","'N'",

should be:

GetSQLValueString(isset($_POST['Uniforms']) ? "true" : "", "defined","'Y'","'N'"),

Report · Dec 18, 2009

Thank-you, that was it. Looked at some other advice you had given to others with similar problems and went back to check for any other corruptions. So I found a few other things that needed some adjustments as well. Thanks again. Patty