1){ $id2=$map_id1; } include("checkfiles.php"); ///Just add-1 for my foolishness for ($pt=$T21;$pt<=$T28; $pt++){ $complete[$pt]=""; } for ($pt=$T21;$pt<=$T28; $pt++){ $sq112abc="SELECT * FROM $table_name78 WHERE test_type ='$map_id1' AND survey_id='$pt' "; $result112abc = @mysql_query($sq112abc,$connection) or die(mysql_error()); $num3334b[$pt] = mysql_num_rows($result112abc); if ($num3334b[$pt]>0) { $complete[$pt]=""; } //else { // $complete[$pt]=""; // } //end else } //end for //// for ($pt=$T21;$pt<=$T28; $pt++){ $test_type=$map_id1; $sq112ab="SELECT * FROM $table_name78 WHERE test_type ='$test_type' AND app_id='$pt' "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); $num3334[$pt] = mysql_num_rows($result112ab); $result222ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row1b = mysql_fetch_array($result222ab)) { $map_id77= stripslashes($row1b['map_id']); } include("searchColumns1.php"); include("countQuestions1.php"); if ($num3334[$pt]>0) { if ($pt==21){ $choice="map_id"; }else { $choice="test_type"; } $complete[$pt]=""; if ($john99>0){ $bad0 =$bad1; $complete[$pt]=" $bad0 "; } if ($radno>0){ // $bad0 =$bad1; $complete[$pt]=" $bad2 "; } if ($john99>0 AND $radno>0){ $bad0 =$bad1; $complete[$pt]=" $bad0
$bad2 "; } if ($display_block678=="display_block1.php"){ // echo $display_block678; $tag77[$T21]= $Btag77[$T21]; } echo "$tag77[$T21] $T21"; $seeme[$pt]="
"; if ($pt==$T22){ $block2 .="

$start77[$T22]

$seeme[$T22] $complete[$T22]"; } // $start77[$pt]=$tag77[$pt]; $start77[$pt]=''; //$vtag77[$pt] } else { $complete[$pt]=""; $start77[$pt]=" " ; if ($pt !=$specialTrepeat ){ $seeme[$pt]=''; } } //end else // echo "$seeme[$pt]
hi"; } //end for /// include("checkfiles.php"); include("$display_block678"); if ($jedID2 == 5) { include("post_variables_survey1.php"); $Rtoday=date("Y-m-d h:i:s"); $log=$_GET['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 = @mysql_query($sql33,$connection) or die(mysql_error()); $row22 =mysql_fetch_array($result33,MYSQL_ASSOC); $display_title= $row22['name']; $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 = @mysql_query($sql112b,$connection) or die(mysql_error()); $num331a = mysql_num_rows($result112a); if ($num331a<1){ $sql2 = "INSERT INTO $table_name78 (survey_id,Ascore, app_id, agent_id, customer_id, create_date , test_type, 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 ', '$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 = @mysql_query($sql2,$connection) or die(mysql_error()); $sql3333 ="SELECT map_id FROM $table_name78 WHERE (email= '$email'AND create_date ='$Rtoday' )"; $result112aa = @mysql_query($sql3333,$connection) or die(mysql_error()); while ($row112aa = mysql_fetch_array($result112aa)) { $map_id= $row112aa['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 ', '$company', '$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 = @mysql_query($sql2,$connection) or die(mysql_error()); $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 = @mysql_query($sql2,$connection) or die(mysql_error()); $sql3333a ="SELECT * FROM $table_name82 WHERE (map_id= '$map_id' )"; $result112aaa = @mysql_query($sql3333a,$connection) or die(mysql_error()); while ($row112aaa = mysql_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 ', '$company', '$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 ', '$company', '$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 = @mysql_query($sql2,$connection) or die(mysql_error()); $something .= "You have completed the Assessment.

Below is feedback based upon our review of your assessment:" ; } else{ include("updater_report.php"); } include("special_report.php"); $display_block77 .="$something

$comments7

"; } ?> <? echo "$display_title"; ?> <? echo "$survey_num"; ?> jedID2=<? echo "$jedID2"; ?>id2=<? echo "$id2"; ?>map_id1=<? echo "$map_id1-$num3334[22]"; ?>