"; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($qq)){ if(STRTOUPPER($row['gender']) == STRTOUPPER($aa)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "
LAST NAME FIRST NAME M.I ALIAS GENDER BIRTHDATE AGE DATE HIRED
" . STRTOUPPER($row['lname']) . "" . STRTOUPPER($row['fname']) . "" . STRTOUPPER($row['mname']) . "" .STRTOUPPER($row['alias']) . "" .STRTOUPPER($row['gender']) . "" .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 "" .STRTOUPPER($row['date_hired']) . "
"; echo ""; ?>