Refresh List
"; $display_status .=""; $sq112ab="SELECT * FROM $table_name362 WHERE customer_group_id >8 ORDER BY name ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['customer_group_id']; $cgfirst_id= $row112ab['name']; $last_id= $row112ab['lastname']; $display_listCustGroup .= ""; } //List of Surveys //$sq112ab="SELECT * FROM $table_name36 where customer_group_id =$leader_id_stat OR customer_group_id =$overseer_id_stat ORDER BY lastname ASC "; $sq112ab="SELECT * FROM $table_name81 ORDER BY name ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['survey_id']; $first_id= $row112ab['name']; //$last_id= $row112ab['lastname']; $display_listL .= ""; // $display_listCustGroup .= ""; } //find the surveys listed for metric $sq112cb="SELECT * FROM $table_name705 Where group_id ='$survey_id' ORDER BY leader_id "; $result112cb = @mysql_query($sq112cb,$connection) or die(mysql_error()); while ($row112cb = mysql_fetch_array($result112cb)) { $leader_idz= $row112cb['leader_id']; //Questions $sq112ab="SELECT * FROM $table_name76 Where survey_id='$leader_idz' ORDER BY surveyQQ_id ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['surveyQQ_id']; $leader_id1N= $row112ab['surveyQ_id']; $gi=$gi+1; $first_id= $row112ab['question']; // $last_id= $row112ab['lastname']; // $display_listL_A .= ""; // $display_listO .= ""; //sum3 // $display_listCustGroup .= ""; //sum4 } $gi=0; } $sq112ab="SELECT * FROM $table_name704 Where dropdown_id='1' ORDER BY value ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['table_id']; $first_id= $row112ab['value']; //$last_id= $row112ab['lastname']; $display_listL_Adm .= ""; //operation 1 $display_listS .= ""; //operation 2 } $sq112ab="SELECT * FROM $table_name36 ORDER BY lastname ASC"; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['customer_id']; $first_id= $row112ab['firstname']; $last_id= $row112ab['lastname']; $display_listO .= ""; // echo $display_listO; } //$sq112ab="SELECT * FROM $table_name36 ORDER BY lastname ASC"; // $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); //while ($row112ab = mysql_fetch_array($result112ab)) { // $leader_id1= $row112ab['customer_id']; // $first_id= $row112ab['firstname']; // $last_id= $row112ab['lastname']; // $display_listS .= ""; //} //$sq112ab="SELECT * FROM $table_name36 where customer_group_id =$other_id_stat ORDER BY lastname ASC"; //$sq112ab="SELECT * FROM $table_name704 Where (table_id>'15'AND table_id<='20') Or table_id='25' Or dropdown_id='2' ORDER BY value ASC"; $sq112ab="SELECT * FROM $table_name704 Where dropdown_id='2' ORDER BY value ASC"; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['table_id']; $first_id= $row112ab['value']; $last_id= $row112ab['lastname']; $display_listOth .= ""; } $sq112aaD ="SELECT * FROM $table_nameApp Where survey_id ='$survey_id' "; $result333D = @mysql_query($sq112aaD,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result333D); while ($row1D = mysql_fetch_array($result333D)) { $survey_id= $row1D['survey_id']; $Cname= stripslashes($row1D['name']); $Ccomments= stripslashes($row1D['comment']); $sq112aaE ="SELECT * FROM $table_name705 Where group_id ='$survey_id' "; $result333E = @mysql_query($sq112aaE,$connection) or die(mysql_error()); while ($row1E = mysql_fetch_array($result333E)) { $leader_match_id= $row1E['leader_match_id']; $leader_id= $row1E['leader_id']; $leader_idA= $row1E['leader_idA']; $leader_idB= $row1E['leader_idB']; $searchP= $row1E['searchP']; $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$leader_idA' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); $surv_B= $row161['survey_id']; $surv_QB= $row161['surveyQ_id']; $sq112ab1="SELECT * FROM $table_name77 Where surveyQ_id='$surv_QB'AND survey_id='$surv_B' ORDER BY surveyA_id ASC "; $result112ab1 = @mysql_query($sq112ab1,$connection) or die(mysql_error()); while ($row112ab1 = mysql_fetch_array($result112ab1)) { $leader_id1N2= $row112ab1['surveyA_id']; $first_id1= $row112ab1['answer']; //sum1 $display_listL_B .= ""; //sum2 } $gii=0; $sq112abVV="SELECT * FROM $table_name76 Where survey_id=' $leader_id' ORDER BY surveyQQ_id ASC "; $result112abVV = @mysql_query($sq112abVV,$connection) or die(mysql_error()); while ($row112abVV = mysql_fetch_array($result112abVV)) { $leader_id1= $row112abVV['surveyQQ_id']; $leader_id1N= $row112abVV['surveyQ_id']; $gii=$gii+1; $first_id= $row112abVV['question']; // $last_id= $row112ab['lastname']; $display_listL_A .= ""; } $sq112ab1="SELECT * FROM $table_name77 Where surveyA_id='$leader_idB' "; $result112ab1 = @mysql_query($sq112ab1,$connection) or die(mysql_error()); while ($row112ab1 = mysql_fetch_array($result112ab1)) { // $leader_id1N2B1B= $row112ab1['surveyA_id']; $Lfirst_idB1B=$row112ab1['answer']; //sum1 // $display_listL_B1 = ""; //sum2 } $leader_idAdm= $row1E['leader_idAdm']; $Cstatus= ($row1E['status']); $Ccreate_date= $row1E['create_date']; $EditQ= $row1E['EditQ']; $EditA= $row1E['EditA']; $Cstatus2[1]="Enabled"; $Cstatus2[0]="Disabled"; $sql361 ="SELECT * FROM $table_name81 WHERE survey_id = '$leader_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_id == $row161['survey_id']) { $Lfirst_id= $row161['name']; //$Llast_id= $row161['lastname']; } else{ //$Llast_id=''; $Lfirst_id=''; } $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$leader_idA' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idA == $row161['surveyQQ_id']) { $Lfirst_idA= $row161['question']; // $Llast_idA= $row161['lastname']; }else{ //$Llast_idA=''; $Lfirst_idA=''; } $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$leader_idB' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idB == $row161['surveyQQ_id']) { $Lfirst_idB= $row161['question']; //$Llast_idB= $row161['lastname']; }else{ //$Llast_idB=''; $Lfirst_idB=''; } $sql361 ="SELECT * FROM $table_name704 WHERE table_id = '$leader_idAdm' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idAdm == $row161['table_id']) { $Lfirst_idAdm= $row161['value']; //$Llast_idAdm= $row161['lastname']; }else{ //$Llast_idAdm=''; $Lfirst_idAdm=''; } $overseer_id= $row1E['overseer_id']; $sql361 ="SELECT * FROM $table_name36 WHERE customer_id = '$overseer_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($overseer_id == $row161['customer_id']) { $OLfirst_id= $row161['firstname']; $OLlast_id= $row161['lastname']; }else{ $OLlast_id=''; $OLfirst_id=''; } $support_id= $row1E['support_id']; $sql361 ="SELECT * FROM $table_name704 WHERE table_id = '$support_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($support_id == $row161['table_id']) { $SLfirst_id= $row161['value']; //$SLlast_id= $row161['lastname']; } else{ //$SLlast_id=''; $SLfirst_id=''; } $other_id= $row1E['other_id']; $sql361 ="SELECT * FROM $table_name704 WHERE table_id = '$other_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($other_id == $row161['table_id']) { $OthLfirst_id= $row161['value']; $OthLlast_id= $row161['lastname']; }else{ $OthLlast_id=''; $OthLfirst_id=''; } $gother_id= $row1E['customer_group_id']; $sql361 ="SELECT * FROM $table_name362 WHERE customer_group_id = '$gother_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($gother_id == $row161['customer_group_id']) { $gOthLfirst_id= $row161['name']; } else{ $gOthLfirst_id=''; } $Ccreate_dateE= $row1E['create_date']; // } if ($Ccreate_date==$blink){ // $Ccreate_date="

No leader records created for this group

"; } $display_entry .="

$survey_id-$leader_match_id $Ccreate_date
$Cname
$Ccomments $Leader:
$Leader_A:
Search Phrase:
$Leader_B:
$Administrator:
$Pastor_Support:
$Admin_Support:
$Additional_Group: $Cstatus2[$Cstatus]

Delete
Select Update

"; $gother_id=''; $other_id=''; $support_id=''; $overseer_id=''; $leader_idAdm=''; $leader_idA=''; $leader_idB=''; $leader_id=''; $OthLfirst_id=''; $OthLlast_id=''; $gOthLfirst_id=''; $SLfirst_id=''; $SLlast_id =''; $OLfirst_id=''; $OLlast_id=''; $Lfirst_idAdm=''; $Llast_idAdm=''; $Lfirst_idB =''; $Llast_idB=''; $Lfirst_idA=''; $Llast_idA =''; $Lfirst_id=''; $Llast_id=''; $Lfirst_idB1B=''; $Llast_idB1B=''; $display_listL_A = ""; $display_listL_B=''; // $display_listO = ""; //sum3 // $display_listCustGroup =''; Need full list of Cust //$display_listL_B=''; $surv_B= ''; $surv_QB= ''; } $display_entry .="

$Cname
$Ccomments $Leader:
$Leader_A:
Search Phrase:
$Leader_B:
$Administrator:
$Pastor_Support:
$Admin_Support:

$Additional_Group: $Cstatus2[$Cstatus]
Add Elements

"; //$edit_block .="

Ability to Edit $Record: Status $Cstatus2D[$EditQD]
// Ability to Edit Answers: Status $Cstatus2D[$EditAD]

"; } // Add Stakeholder: Customer, Leader, Support Person, etc.
$display_blockV .=" $bottomRepReset
Note: [Sum1 (Operation1) Sum2] (operation2) [Sum3 (operation3) Sum4]
ie: [Sum1 difference Sum2] divisor [Sum3 multipy Sum4] = [Sum1-Sum2]/[Sum3 *Sum4]
Use of a timeframe nullifies use of Sum4 Column. Count in Operation 1 Does not use the Sum2 column. Count in Operation 2 Does nothing. Count in Operation 3 Does not use Sum4. Note: Below: Sort Function is Case-Sensitive. Date sort is Format-Sensitive. $display_entry

	$Record ID	Date Added $Record Title $Record Summary	$Leader $Leader_A $Leader_B $Administrator $Pastor_Support $Admin_Support $Additional_Resource $Additional_Group	Status	Action

$noteB

Showing Results: $num33 Record(s)"; ?>