I am building a survey, in which participants use a html form to enter details.For example:\[code\]What gender are you? Male | Female \[/code\]The Male/Female option can be selected using a radio button.However, I would like to store the answer in my database as an INT value, which is 0 for male and 1 for female. How do I write a query which represents that?I have a rough idea which looks like this, but doesn't seem to work:\[code\]$__g = Array('male' => '0', 'female' => '1');\[/code\]And also, how do I insert the value into the database? I have this, but am unsure if it works (since I can't get the representing part correct)\[code\]$sql = "INSERT INTO `onlinesurvey` (gender) VALUES ('".$__g[$_POST['gender']]."');\[/code\]Many thanks for your help =)