function prefNameFromEmail($email) { if ($email == '') { return ''; } $sql = "SELECT prefName FROM `member` WHERE email='{$email}';"; $result = mysql_fetch_array(mysql_query($sql)); if ($result["prefName"] == '') { return firstNameFromEmail($email); } return $result["prefName"]; }
function fullNameFromEmail($email) { return firstNameFromEmail($email) . " " . lastNameFromEmail($email); }