REC. ID | NAME | COMPANY |
---|
";
$getExecomList = mysql_query("SELECT * FROM `vts_users` WHERE `buyer`=1 ORDER BY `u_lname` ASC");
while($row=mysql_fetch_array($getExecomList)){
$companyName=mysql_result(mysql_query("SELECT comp_name FROM vts_company WHERE comp_id='".$row['company']."'"),0);
?>
".$row['u_id']."
".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."
".strtoupper($companyName)." ";
echo " ";
}
echo "";
?>
SELECT EMPLOYEE:
EMPLOYEE NAME:
BUYERS:
Only employees assigned as buyer can be seen in the buyer setup and buyer assignment module. If employee doesn't exist in the list, you need to add that employee here to include them in the buyers selection.
Only employees assigned as buyer can be seen in the buyer setup and buyer assignment module. If employee doesn't exist in the list, you need to add that employee here to include them in the buyers selection.