How to display Text when DB value is 1

My Setup.
I have a Select field for Gender which inserts figure 1 into the dB when Male is selected and 2 when Female is selected.

<div class="form-group mb-3">
  <label for="inp_gender" class="form-label col-form-label">Select Gender</label>
  <select id="inp_gender" class="form-select" name="gender" required="">
  <option value="1">Male</option><option value="2">Female</option></select>

When I pull the data from the DB, I want to display the actual select options (Male and Female) on the front instead of figures 1 and 2. How do I do this? Is there any way to do this using any of the conversion functions?

Community Page
Last updated: