insert rec get value frm radio button

[Anon]

Hi,

How can i get value from radio button and insert it into my mysql database.
How should my insert statement look like?
For the html text block my insert stmt will look something like this;

insert into customer_info
(company_name)
values
('$T1');

which T1 is actually referrring to the name for the company name html text.
But for the radio button how do i convert it to value in order to insert into database.

Pls see my partial script below;

--------------START------------------------
<center>
<table border="1" width="700" cellspacing="0" cellpadding="0" height="41">
<tr>
<td width="100%" height="21" colspan="2">
<br>
<font face="Verdana" size="2">
&nbsp;&nbsp;&nbsp; 12. Reason(s) for Application :</font><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="radio" value="V1" checked name="R1">Voluntary</font><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;
<input type="radio" value="V2" checked name="R2">Parent company/franchise requirement</font><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;
<input type="radio" value="V3" checked name="R3">Export requirement (please state the country you're exporting to) :</font><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

------------------END----------------------------------

--shah