// // // // // $goflow="Survey List"; //$jed=2; $jed=$jedID2; $gjed=1; $bottomRepReset .="Refresh
"; $bottomReport .="

Search Notes for term:

And: Or:

Leave fields blank and hit Submit to reset report.

"; $special_code .=" "; $sbad=$_POST['sbad']; $look1=$_POST['look1']; $look1="%$look1%"; $searchR=$_POST['searchR']; $look2=$_POST['look2']; $look2="%$look2%"; $delID=$_POST['lookD']; if ($sbad==0){ $sq112a="SELECT * FROM $table_name81 "; } if (($sbad==1)AND($look2==$blink)){ $sq112a="SELECT * FROM $table_name81 Where (name Like '$look1'') OR (comment Like '$look1')"; } if (($sbad==1)AND ($searchR==1)AND ($look2!=$blink)){ $sq112a="SELECT * FROM $table_name81 Where ((comment Like '$look1')AND (comment Like '$look2')) OR ((name Like '$look1')AND (name Like '$look2')) "; } if (($sbad==1)AND ($searchR==2)AND ($look2!=$blink)){ $sq112a="SELECT * FROM $table_name81 Where ((comment Like '$look1')OR (comment Like '$look2')) OR ((name Like '$look1')OR (name Like '$look2')) "; } if ($sbad==10){ if ($delID != 1){ $sq112az="DELETE FROM $table_name81 WHERE survey_id ='$delID'"; $result331 = @mysql_query($sq112az,$connection) or die(mysql_error()); $warn= "
Record Deleted
"; }else{ $warn= "
You cannot delete the Base Survey.
"; } $sq112a="SELECT * FROM $table_name81 "; } $result33 = @mysql_query($sq112a,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result33); $Cstatus2[1]="Enabled"; $Cstatus2[0]="Disabled"; $result222 = @mysql_query($sq112a,$connection) or die(mysql_error()); while ($row1 = mysql_fetch_array($result222)) { $survey_id= $row1['survey_id']; $Cname= stripslashes($row1['name']); $Ccomments= stripslashes($row1['comment']); $Cstatus= stripslashes($row1['status']); $Ccreate_date= $row1['create_date']; $del_list .=""; $display_entry .="

$survey_id $Ccreate_date $Cname $Ccomments $Cstatus2[$Cstatus] Select This Survey
"; } $sq112aaD ="SELECT * FROM $table_name81 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']; $CnameD= stripslashes($row1D['name']); $CcommentsD= stripslashes($row1D['comment']); $CstatusD= stripslashes($row1D['status']); $CcreateD_date= $row1D['create_date']; $EditQD= $row1D['EditQ']; $EditAD= $row1D['EditA']; $Cstatus2D[1]="Enabled"; $Cstatus2D[0]="Disabled"; $edit_block .="
Ability to Edit Questions: Status $Cstatus2D[$EditQD]
Ability to Edit Answers: Status $Cstatus2D[$EditAD]
"; } $bottomDelete .="
Select ID to Delete:

Hit Submit to Delete.

"; include("note.php"); // $noteC - We've removed deletion on this page $display_blockV .="

$\"\"$ $goflow

$noteB $bottomRepReset

Current Survey:
$display_blockAdmin

Edit Survey Below:
$edit_block
$Question_stuff $display_blockAdmin3

Note: Below: Sort Function is Case-Sensitive. Date sort is Format-Sensitive. $display_entry

Survey ID Date Added Survey Title Survey Summary Status Action

$noteB

Showing Results: $num33 Record(s)

"; ?>