query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } ?> REC.ID EMP. ID COMPANY BRANCH FIRST NAME LAST NAME POSITION 0){ while($row = mysqli_fetch_array($getEmpQ)){ $myCompID = $row['comp_id']; $myDealID = $row['branch_id']; $myPosID = $row['position']; ?>".$row['id'].""; echo "".$row['emp_id'].""; echo ""; $getCompany = "SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$myCompID'"; $getC = mysqli_query($conn,$getCompany); while($rowX = mysqli_fetch_array($getC)){ echo $rowX['comp_code']; } echo ""; echo ""; $getDealer = "SELECT `deal_code` FROM `vts_dealerships` WHERE `deal_id`='$myDealID'"; $getD = mysqli_query($conn,$getDealer); while($rowD = mysqli_fetch_array($getD)){ echo strtoupper($rowD['deal_code']); } echo ""; echo "".strtoupper($row['first_name']).""; echo "".strtoupper($row['last_name']).""; echo ""; $getPos = "SELECT `position_name` FROM `pms_positions_tbl` WHERE `id`='$myPosID'"; $getP = mysqli_query($conn,$getPos); while($rowP = mysqli_fetch_array($getP)){ echo strtoupper($rowP['position_name']); } echo ""; echo "";?> "; echo "";?> "; echo " "; echo ""; } } $conn->close(); } ?>