"; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); if($newAge == $aa){ $pID = $row['id']; $getCourse = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `education` WHERE `talent_id`='$pID' AND `course` LIKE '%$aa%' ORDER BY `date_graduated` LIMIT 1 "),0); //echo "My COURSE" .$getCourse; if($getCourse > 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } } echo "

	LAST NAME	FIRST NAME	M.I	ALIAS	BIRTHDATE	AGE	DATE HIRED
	" . STRTOUPPER($row['lname']) . "	" . STRTOUPPER($row['fname']) . "	" . STRTOUPPER($row['mname']) . "	" .STRTOUPPER($row['alias']) . "	" .STRTOUPPER($row['birthdate']) . "	"; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); if($newAge > 0){ echo $newAge; } echo "	"; $myCourse = mysql_result(mysql_query("SELECT `course` FROM `education` WHERE `talent_id`='$pID' AND `course` LIKE '%$aa%' ORDER BY `date_graduated` LIMIT 1 "),0); echo STRTOUPPER($myCourse); echo "

"; echo ""; ?>