LEVEL | DESCRIPTION | MIN. AMOUNT | MAX. AMOUNT | REQUIRED EXECOM | REQUIRED APPROVER |
---|
";
while($row=mysql_fetch_array($getMatrixData)){
$fixApprover = $row['requiredApproverID'];
$fixAPproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0);
$fixAPproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$fixApprover'"),0);
?>".$row['level']."";
echo "".$row['description']." ";
echo "".$row['min_amount']." ";
echo "".$row['max_amount']." ";
echo "".$row['requiredExecom']." ";
echo "".strtoupper($fixAPproverLName).", ".strtoupper($fixAPproverFName)." ";
echo " ";
}
echo "";
?>
Matrix Data:
Level:
Description:
Min. Amount:
Max. Amount:
Req. EXECOM:
Fixed Approver: