0){ while($row = mysqli_fetch_array($getGroup)){ $pcpEmpID = $row['pms_officer_id']; $pmsCompID = $row['comp_id']; $sqlOps = "SELECT * FROM `ops_autohub_level` WHERE `record_id`='$pmsCompID' AND `status` ='OPEN' ORDER BY `id` ASC "; $qOps = mysqli_query($conn,$sqlOps); while($ops=mysqli_fetch_array($qOps)){ $count = $count + 1; $recordID = $ops['id']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } }else{ echo "

No record found.

"; } }else{ $sqlOps = "SELECT * FROM `ops_autohub_level` WHERE `record_id`='$selCompID' AND `deleted`='0' ORDER BY `id` ASC "; $qOps = mysqli_query($conn,$sqlOps); while($ops=mysqli_fetch_array($qOps)){ $count = $count + 1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>

NO	YEAR	COMPANY	OPSPLAN DESCRIPTION	STATUS
".$count."	".$ops['coverage_year']."	".strtoupper(getAutohubGroupName($ops['record_id'])[0])."	".strtoupper($ops['ops_name'])."	".$ops['status']."
".$ops['id']."	".$ops['coverage_year']."	".strtoupper(getAutohubGroupName($ops['record_id'])[0])."	".strtoupper($ops['ops_name'])."	".$ops['status']."

close(); } ?>