"; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $tID = $row['talent_id']; $dateOfBirth = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$tID'"),0); $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); $lName = mysql_result(mysql_query("SELECT `lname` FROM `talents_profile` WHERE `id`='$tID'"),0); $fName = mysql_result(mysql_query("SELECT `fname` FROM `talents_profile` WHERE `id`='$tID'"),0); $Alias = mysql_result(mysql_query("SELECT `alias` FROM `talents_profile` WHERE `id`='$tID'"),0); $gender = mysql_result(mysql_query("SELECT `gender` FROM `talents_profile` WHERE `id`='$tID'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
LAST NAME FIRST NAME ALIAS GENDER AGE SKILLS / TALENTS
" . STRTOUPPER($lName) . "" . STRTOUPPER($fName) . "" . STRTOUPPER($Alias) . "" .STRTOUPPER($gender) . ""; echo $newAge; echo "" .STRTOUPPER($row['title']).": " .STRTOUPPER($row['description']) . "
"; echo ""; ?>