Field "Types" in phpMyAdmin?

Question

hi. i need help with understanding the field 'types' in phpMyAdmin. the definitions in their resource page is confusing for me. i need to find out what field type i should use for the following:
- text field with 25 characters
- date field
- a radio button in my form

the radio button i have in my form is a simple "male" or "female" button which the visitor must choose just one. what type of field & value in my database do i use for that?

thanks.

Answer 1

In PHPMyAdmin set the datafields to the following types:

Text field with 25 characters = varchar(25)
Date field = date
Radio button = char(1)

Cheers!

Answer 2

tinyint
assign yoru radio button for male as a value of 1
assign your radio button fore female as a value of 2
when you do your query to retrieve the data from your database, you know that if you choose all rows with 1 in that field, that it will only display those who are males.

etc