";
echo "";
echo "| REC.ID. | ";
echo "LAST NAME | ";
echo "FIRST NAME | ";
echo "POSITION | ";
echo "COMPANY | ";
echo "";
$getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC");
while($row=mysql_fetch_array($getApproverList)){
$uID = $row['u_id'];
$getCompID = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$getCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$getCompID'"),0);
$count = $count + 1;
?>
".$row['u_id']."";
echo "| ".strtoupper($row['u_lname'])." | ";
echo "".strtoupper($row['u_fname'])." | ";
echo "".strtoupper($row['u_position'])." | ";
echo "".strtoupper($getCompName)." | ";
echo "
";
}
echo "";
?>
