I created a select list box in the following format
Gender
1|Male
2|Female
I want to display the follwing information in a table but I am getting "1" for male and "2" for female.
here is my code
function display_results_submissions(){
$results = db_query("SELECT * FROM {users}");
$header = array( t('Name'), t('Mail'), t('Gender'),);
foreach($results as $result){
$rows[] = array(
$result->name,
$result->mail,
$result->gender,
);
}
return theme('table', array('header' => $header, 'rows'=>$rows));
}
I want to display Male or Female instead of "1" and "2"