how can i display 1 and 0 as active and inactive

[kevs]

if i inserted this in database it will set as 1 or 0

but i want to pull it and display as active and inactive

<select name="status">
<option value="1">Active</option>
<option value="0">Inactive</option>
</select>

[Luuk]

select i, case i when 1 then 'active' else 'inactive' end ANSWER from ints 
where i=1;
 

this shows:

+---+--------+
| i | ANSWER |
+---+--------+
| 1 | active |
+---+--------+
 

[Exequiel]

i think you can do it this way.
sample table.

-------status-------
id | statusname |
----------------
1 | 1 | //for active
---------
2 | 0 | //for inactive
---------

sample code to view

$htmlstat = "";
$string = "";
 
$status = mysql_query("SELECT * FROM status");
while($stat = mysql_fetch_array($status))
{
   if($stat['statusname'] == 1)
   {
      $string = "Active";
   }
   else
  {
     $string = "Inactive";
  }
   $htmlstat += '<option value="'.$stat['status'].'">'.$string.'</option>';
 
}
echo '<select name="status">'.$htmlstat.'</select>';

[/code]