Single record insert will not create session variable
I have been trying for 5 hours to get Single record insert to create the session variable so I can filter the database and email the result from the success page. it's not working
Everything on the page is inserting correctly and the uploading (2 files) correctly but it will not create a session variable.
DW CS3 latest ver of data assist
<?php
// WA Application Builder Insert
if ($_SERVER["REQUEST_METHOD"] == "POST") // Trigger
{
$WA_connection = $daves;
$WA_table = "estimates";
$WA_sessionName = "estimates_estimates_id";
$WA_redirectURL = "success.php";
$WA_keepQueryString = false;
$WA_indexField = "estimates_id";
$WA_fieldNamesStr = "estimates_first_name|estimates_last_name|estimates_address|estimates_city|estimates_state|estimates_zip|estimates_phone|estimates_email|estimates_model|estimates_make|estimates_year|estimates_desc|estimates_pic_1|estimate_pic_1_thumb|estimates_pic_2|estimate_pic_2_thumb";
$WA_fieldValuesStr = "".((isset($_POST["estimates_first_name"]))?$_POST["estimates_first_name"]:"") ."" . "|" . "".((isset($_POST["estimates_last_name"]))?$_POST["estimates_last_name"]:"") ."" . "|" . "".((isset($_POST["estimates_address"]))?$_POST["estimates_address"]:"") ."" . "|" . "".((isset($_POST["estimates_city"]))?$_POST["estimates_city"]:"") ."" . "|" . "".((isset($_POST["estimates_state"]))?$_POST["estimates_state"]:"") ."" . "|" . "".((isset($_POST["estimates_zip"]))?$_POST["estimates_zip"]:"") ."" . "|" . "".((isset($_POST["estimates_phone"]))?$_POST["estimates_phone"]:"") ."" . "|" . "".((isset($_POST["estimates_email"]))?$_POST["estimates_email"]:"") ."" . "|" . "".((isset($_POST["esitmates_model"]))?$_POST["esitmates_model"]:"") ."" . "|" . "".((isset($_POST["estimates_make"]))?$_POST["estimates_make"]:"") ."" . "|" . "".((isset($_POST["estimates_year"]))?$_POST["estimates_year"]:"") ."" . "|" . "".((isset($_POST["estimates_damage_desc"]))?$_POST["estimates_damage_desc"]:"") ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"] ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_2"]["serverFileName"] ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult2"]["WA_UploadResult2_1"]["serverFileName"] ."" . "|" . "".$WA_DFP_UploadStatus["WA_UploadResult2"]["WA_UploadResult2_2"]["serverFileName"] ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_daves;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$_SESSION[$WA_sessionName] = mysql_insert_id();
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>