"; echo ""; while($row = mysql_fetch_array($qEmp)){ $count = $count + 1; $empID = $row['employee_id']; $checkIfExist = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_invites` WHERE `employee_id`='$empID' AND `schedule_id`='$xID'"),0); if($checkIfExist > 0){ }else{ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

FILTER EMPLOYEES	LIST OF EMPLOYEES	INVITED EMPLOYEES
'> '> '> '> '> '> '> '> '> SELECT COMPANY: ".$row['name']."---".$row['code'].""; } ?> SELECT DEALERSHIP: ".$row['name']."---".$row['dcode'].""; } ?> SELECT DEALERSHIP: ".$row['name']."---".$row['code'].""; } ?>	"; echo "
LAST NAME	FIRST NAME	POSITION
" . $row['last_name'] . "	" . $row['first_name'] . "	" . $row['position'] . "	"; echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo " "; echo "

"; ?>

"; echo " LAST NAME FIRST NAME "; echo ""; while($iRow = mysql_fetch_array($qEmp)){ $count = $count + 1; $empID = $iRow['employee_id']; $fname = mysql_result(mysql_query("SELECT `first_name` FROM `employee_list` WHERE `employee_id`='$empID'"),0); $lname = mysql_result(mysql_query("SELECT `last_name` FROM `employee_list` WHERE `employee_id`='$empID'"),0); $position = mysql_result(mysql_query("SELECT `position` FROM `employee_list` WHERE `employee_id`='$empID'"),0); echo ""; echo ""; echo strtoupper($lname); echo ""; echo ""; echo strtoupper($fname); echo""; echo ""; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; echo ""; echo ""; } echo ""; ?>