将mysql中的数字更改为字母以在php中回显

Question

In regard to a previous question I just managed to get solved by a very generous person. I have but 1 more issue. I'm echo'ing the Online Users logged into my Website; however I also want to echo their Gender. Now the problem is, the Gender's are stored as 0 & 1 instead of male and female. I have tried but I can't seem to get it working... my code;

$result = mysql_query("SELECT DISTINCT name, gender FROM online INNER JOIN base ON  online.ID = base.id limit 8 "); 
switch($gender)
{
    case 0: $gen='Male'; break;
    case 1: $gen='Female'; break;
    default: $gen='Undecided'; break;
}
echo "<table class='table table-hover' width='300'><tr></tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['gender'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "</tr>";
}
echo "</table>";

This script does not work, but perhaps someone can shine some light upon a solution? I'd be very grateful!

Answer 1

$result = mysql_query("SELECT DISTINCT name, gender FROM online INNER JOIN base ON online.ID = base.id limit 8 "); 

function getGenderText($genderId) {
    $genders = array('Male', 'Female');
    return isset($genders[$genderId]) ? $genders[$genderId] : 'Undecided';
}

echo "<table class='table table-hover' width='300'><tr></tr>";
while($row = mysql_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . getGenderText($row['gender']) . "</td>";
    echo "<td>" . $row['name'] . "</td>";
    echo "</tr>";
}
echo "</table>";