Remember this is a timed test. ";
$final_sub_warn .=" First Name: Last Name: First Name: Last Name: Organization: Telephone (W): Telephone (H): Telephone (C): Telephone (F): Address: City: State or Province:
$stateH $display_state Country: $countryH
$display_countryPostal Code: First Name: Last Name: Patient ID: Organization: ";
$answerA1[$surveyQ_id] .=" $answer[$surveyA_id] ";
$answerA ="$topAA $answerA1[$surveyQ_id] State: $state
$display_state Country: $country
$display_country
Administration
";
if ($jedID2 == 0) {
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_num'AND administrative =0 AND surveyQ_id > '$num33' AND surveyQ_id <'$num_round1' ";
$result112a = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row112a = mysqli_fetch_array($result112a)) {
$surveyQ_id= $row112a['surveyQ_id'];
$question["$surveyQ_id"]= $row112a['question'];
$comment["$surveyQ_id"]= $row112a['comment'];
$administrative["$surveyQ_id"]= $row112a['administrative'];
$sq112b="SELECT * FROM $table_name77 Where survey_id ='$survey_num'AND surveyQ_id ='$surveyQ_id' Order By surveyA_id";
$result112b = @mysqli_query($connection,$sq112b) or die(mysqli_error($connection));
while ($row112b = mysqli_fetch_array($result112b)) {
$surveyA_id= $row112b['surveyA_id'];
$test_type= $row112b['test_type'];
$answer["$surveyA_id"]= $row112b['answer'];
$commentA[$surveyA_id] = $row112b['comment'];
$points[$surveyA_id]= $row112b['A_points'];
if($test_type ==0){
$answerA .=" ";
$answerA1[$surveyQ_id] .=" $answer[$surveyA_id] ";
$answerA ="$topAA $answerA1[$surveyQ_id] State: $state
$display_state Country: $country
$display_country
Questions
";
if ($jedID2 == 0) {
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_num'AND administrative =0 AND surveyQ_id >= '$num_round1'AND surveyQ_id < '$num_round2' ";
$result112a = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row112a = mysqli_fetch_array($result112a)) {
$surveyQ_id= $row112a['surveyQ_id'];
$question["$surveyQ_id"]= $row112a['question'];
$comment["$surveyQ_id"]= $row112a['comment'];
$administrative["$surveyQ_id"]= $row112a['administrative'];
$sq112b="SELECT * FROM $table_name77 Where survey_id ='$survey_num'AND surveyQ_id ='$surveyQ_id' Order By surveyA_id";
$result112b = @mysqli_query($connection,$sq112b) or die(mysqli_error($connection));
while ($row112b = mysqli_fetch_array($result112b)) {
$surveyA_id= $row112b['surveyA_id'];
$test_type= $row112b['test_type'];
$answer["$surveyA_id"]= $row112b['answer'];
$commentA[$surveyA_id] = $row112b['comment'];
$points[$surveyA_id]= $row112b['A_points'];
if($test_type ==0){
$answerA .=" State: $state
$display_state Country: $country
$display_country
Questions
";
if ($jedID2 == 0) {
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_num'AND administrative =0 AND surveyQ_id >= '$num_round2' ";
$result112a = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
while ($row112a = mysqli_fetch_array($result112a)) {
$surveyQ_id= $row112a['surveyQ_id'];
$question["$surveyQ_id"]= $row112a['question'];
$comment["$surveyQ_id"]= $row112a['comment'];
$administrative["$surveyQ_id"]= $row112a['administrative'];
$sq112b="SELECT * FROM $table_name77 Where survey_id ='$survey_num'AND surveyQ_id ='$surveyQ_id' Order By surveyA_id";
$result112b = @mysqli_query($connection,$sq112b) or die(mysqli_error($connection));
while ($row112b = mysqli_fetch_array($result112b)) {
$surveyA_id= $row112b['surveyA_id'];
$test_type= $row112b['test_type'];
$answer["$surveyA_id"]= $row112b['answer'];
$commentA[$surveyA_id] = $row112b['comment'];
$points[$surveyA_id]= $row112b['A_points'];
if($test_type ==0){
$answerA .=" ";
$answerA1[$surveyQ_id] .=" $answer[$surveyA_id] ";
$answerA ="$topAA $answerA1[$surveyQ_id] State: $state
$display_state Country: $country
$display_country
Questions
";
$warning_clock .="
";
$display_block .= " ";
}
if ($jedID2 == 5) {
include("post_variables_survey1.php");
$Rtoday=date("Y-m-d h:i:s");
$log=$_POST['log'];
$testy=$_POST['test'];
$app_id = $testy;
$survey_id2=$app_id;
include("customer_add.php");
$sql33 ="SELECT name FROM $table_name81 WHERE survey_id = '$app_id' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_title= $row22['name'];
// $dptimed= $row22['ptimed'];
// $dcutoff= $row22['cutoff'];
// $dsurvey= $row22['survey_id'];
$agent_id=$log;
//This allows them to only to take the test once.
$sql112b ="SELECT * FROM $table_name78 WHERE survey_id = '$app_id' AND agent_id ='$agent_id' ";
$result112a = @mysqli_query($connection,$sql112b) or die(mysqli_error($connection));
$num331a = mysqli_num_rows($result112a);
if ($num331a>0){
$row22777 =mysqli_fetch_array($result112a,MYSQLI_ASSOC);
$johnboy= $row22777['map_id'];
$johnboy1="Previous ID:$johnboy";
}
if ($num331a<1){
$sql2 = "INSERT INTO $table_name78 (survey_id,Ascore, app_id, agent_id, customer_id, create_date , test_type, company, firstname, email, lastname, van1, van2, van3, van4, van5, van6, van7, van8, van9, van10, van11, van12, van13, van14, van15, van16, van17, van18, van19, van20, van21, van22, van23, van24, van25, van26, van27, van28, van29, van30, van31, van32, van33, van34, van35, van36, van37, van38, van39, van40, van41, van42, van43, van44, van45, van46, van47, van48, van49, van50, van51, van52, van53, van54, van55, van56 )VALUES ('$survey_id2','$finalpoint','$app_id','$agent_id', '$cust_id', '$Rtoday', '$test_type ', '$company2', '$fname','$email','$lname', '$van[1]', '$van[2]', '$van[3]', '$van[4]', '$van[5]', '$van[6]', '$van[7]', '$van[8]', '$van[9]', '$van[10]', '$van[11]', '$van[12]', '$van[13]', '$van[14]', '$van[15]', '$van[16]', '$van[17]', '$van[18]', '$van[19]', '$van[20]', '$van[21]', '$van[22]', '$van[23]', '$van[24]', '$van[25]', '$van[26]', '$van[27]', '$van[28]', '$van[29]', '$van[30]', '$van[31]', '$van[32]', '$van[33]', '$van[34]', '$van[35]', '$van[36]', '$van[37]', '$van[38]', '$van[39]', '$van[40]', '$van[41]', '$van[42]', '$van[43]', '$van[44]', '$van[45]', '$van[46]', '$van[47]', '$van[48]', '$van[49]', '$van[50]', '$van[51]', '$van[52]', '$van[53]', '$van[54]', '$van[55]', '$van[56]')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$sql3333 ="SELECT map_id FROM $table_name78 WHERE (email= '$email'AND create_date ='$Rtoday' )";
$result112aa = @mysqli_query($connection,$sql3333) or die(mysqli_error($connection));
while ($row112aa = mysqli_fetch_array($result112aa)) {
$map_id= $row112aa['map_id'];
$johnboy=$map_id;
}
$sql2 = "INSERT INTO $table_name79 (Ascore, map_id,app_id, agent_id, customer_id, create_date , test_type, company, firstname, email, lastname, van1, van2, van3, van4, van5, van6, van7, van8, van9, van10, van11, van12, van13, van14, van15, van16, van17, van18, van19, van20, van21, van22, van23, van24, van25, van26, van27, van28, van29, van30, van31, van32, van33, van34, van35, van36, van37, van38, van39, van40, van41, van42, van43, van44, van45, van46, van47, van48, van49, van50, van51, van52, van53, van54, van55, van56 ) VALUES ('$finalpoint','$map_id','$app_id','$agent_id', '$cust_id', '$Rtoday', '$test_type ', '$company2', '$fname','$email','$lname', '$Avan[1]', '$Avan[2]', '$Avan[3]', '$Avan[4]', '$Avan[5]', '$Avan[6]', '$Avan[7]', '$Avan[8]', '$Avan[9]', '$Avan[10]', '$Avan[11]', '$Avan[12]', '$Avan[13]', '$Avan[14]', '$Avan[15]', '$Avan[16]', '$Avan[17]', '$Avan[18]', '$Avan[19]', '$Avan[20]', '$Avan[21]', '$Avan[22]', '$Avan[23]', '$Avan[24]', '$Avan[25]', '$Avan[26]', '$Avan[27]', '$Avan[28]', '$Avan[29]', '$Avan[30]', '$Avan[31]', '$Avan[32]', '$Avan[33]', '$Avan[34]', '$Avan[35]', '$Avan[36]', '$Avan[37]', '$Avan[38]', '$Avan[39]', '$Avan[40]', '$Avan[41]', '$Avan[42]', '$Avan[43]', '$Avan[44]', '$Avan[45]', '$Avan[46]', '$Avan[47]', '$Avan[48]', '$Avan[49]', '$Avan[50]', '$Avan[51]', '$Avan[52]', '$Avan[53]', '$Avan[54]', '$Avan[55]', '$Avan[56]')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$sql2 = "INSERT INTO $table_name82 (pat_id, survey_id, map_id, agent_id, zip, telephone, homeP, cell,fax ,addressH, cityH, stateH, countryH, ip, web, create_date, company, firstname, email, lastname) VALUES('$pat_id','$app_id','$map_id','$agent_id', '$zipH', '$phoneW', '$phoneH','$phoneC', '$phoneF', '$addressH', '$cityH', '$stateH', '$countryH', '$ip', '$web', '$Rtoday', '$company', '$fname','$email','$lname')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$sql3333a ="SELECT * FROM $table_name82 WHERE (map_id= '$map_id' )";
$result112aaa = @mysqli_query($connection,$sql3333a) or die(mysqli_error($connection));
while ($row112aaa = mysqli_fetch_array($result112aaa)) {
$cust_id= $row112aaa['customer_id'];
}
$sql2 = "INSERT INTO $table_name80 (pat_id, survey_id, Ascore, map_id, agent_id,app_id, customer_id, create_date , test_type, company, firstname, email, lastname, van1, van2, van3, van4, van5, van6, van7, van8, van9, van10, van11, van12, van13, van14, van15, van16, van17, van18, van19, van20, van21, van22, van23, van24, van25, van26, van27, van28, van29, van30, van31, van32, van33, van34, van35, van36, van37, van38, van39, van40, van41, van42, van43, van44, van45, van46, van47, van48, van49, van50, van51, van52, van53, van54, van55, van56 )VALUES ('$pat_id','$app_id','$finalpoint','$map_id','$agent_id','$app_id', '$cust_id', '$Rtoday', '$test_type ', '$company2', '$fname','$email','$lname', '$van[1]', '$van[2]', '$van[3]', '$van[4]', '$van[5]', '$van[6]', '$van[7]', '$van[8]', '$van[9]', '$van[10]', '$van[11]', '$van[12]', '$van[13]', '$van[14]', '$van[15]', '$van[16]', '$van[17]', '$van[18]', '$van[19]', '$van[20]', '$van[21]', '$van[22]', '$van[23]', '$van[24]', '$van[25]', '$van[26]', '$van[27]', '$van[28]', '$van[29]', '$van[30]', '$van[31]', '$van[32]', '$van[33]', '$van[34]', '$van[35]', '$van[36]', '$van[37]', '$van[38]', '$van[39]', '$van[40]', '$van[41]', '$van[42]', '$van[43]', '$van[44]', '$van[45]', '$van[46]', '$van[47]', '$van[48]', '$van[49]', '$van[50]', '$van[51]', '$van[52]', '$van[53]', '$van[54]', '$van[55]', '$van[56]')";
// $sql2 = "INSERT INTO $table_name80 (map_id, agent_id, customer_id, create_date , test_type, company, firstname, email, lastname, van1, van2, van3, van4, van5, van6, van7, van8, van9, van10, van11, van12, van13, van14, van15, van16, van17, van18, van19, van20, van21, van22, van23, van24, van25, van26, van27, van28, van29, van30, van31, van32, van33, van34, van35, van36, van37, van38, van39, van40, van41, van42, van43, van44, van45, van46, van47, van48, van49, van50, van51, van52, van53, van54, van55, van56 )VALUES ('$map_id','$agent_id', '$cust_id', '$Rtoday', '$test_type ', '$company2', '$fname','$email','$lname', '$Avan[1]', '$Avan[2]', '$Avan[3]', '$Avan[4]', '$Avan[5]', '$Avan[6]', '$Avan[7]', '$Avan[8]', '$Avan[9]', '$Avan[10]', '$Avan[11]', '$Avan[12]', '$Avan[13]', '$Avan[14]', '$Avan[15]', '$Avan[16]', '$Avan[17]', '$Avan[18]', '$Avan[19]', '$Avan[20]', '$Avan[21]', '$Avan[22]', '$Avan[23]', '$Avan[24]', '$Avan[25]', '$Avan[26]', '$Avan[27]', '$Avan[28]', '$Avan[29]', '$Avan[30]', '$Avan[31]', '$Avan[32]', '$Avan[33]', '$Avan[34]', '$Avan[35]', '$Avan[36]', '$Avan[37]', '$Avan[38]', '$Avan[39]', '$Avan[40]', '$Avan[41]', '$Avan[42]', '$Avan[43]', '$Avan[44]', '$Avan[45]', '$Avan[46]', '$Avan[47]', '$Avan[48]', '$Avan[49]', '$Avan[50]', '$Avan[51]', '$Avan[52]', '$Avan[53]', '$Avan[54]', '$Avan[55]', '$Avan[56]')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$something .= "You have completed the Assessment.survey_num <? echo "$survey_num"; ?> jedID2=<? echo "$jedID2"; ?> map_id=<? echo "$map_id"; ?>