";
$getExecomList = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,prf_execommembers.id,prf_execommembers.execom_id,prf_execommembers.authority,prf_execommembers.comp_id FROM `vts_users` JOIN `prf_execommembers` ON `prf_execommembers`.execom_id = vts_users.u_id WHERE `vts_users`.u_id=`prf_execommembers`.execom_id AND `prf_execommembers`.deleted=0 ORDER BY u_lname,authority ASC");
while($row=mysql_fetch_array($getExecomList)){
$getAuthority= $row['authority'];
if($getAuthority == 1){
$exeType ='SINGLE APPROVER - Approval matrix WILL NOT be used';
}
if($getAuthority == 3){
$exeType ='GROUP OF EXECOM - Approval matrix WILL be used';
}
if($getAuthority == 2){
$exeType ='VP / SVP - Approval matrix WILL be used';
}
if($getAuthority == 4){
$exeType ='AVP\'s - Approval matrix WILL be used';
}
?>