I created a select list box in the following format > Gender<br> 1|Male<br> 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"