radio button

[filipel]

Hi.I have 2 radio buttons with name"newsletter".How can i store its value on a mysql table?

 

[feherke]

Hi

At first read I would just push them into the same field, separated with comma ( , ). But of course this depends on what are the values.

Feherke.

http://rootshell.be/~feherke/

 

[jpadie]

do you perhaps mean a radio group? in which case you will only ever receive no or 1 value from a browser. you would insert that value thus

if (isset($_POST['newsletter'])){
 $nlValue = 1;
} else {
 $nlValue = 0;
}
$sql = "Update table set newsletter=$nlValue where id=???";
mysql_query($sql) or die (mysql_error());

i.e. the secret is to test whether anything in the radio group has been set. if you are using string values for the group elements then change the first $nlValue to $nlValue = $_POST['newsletter'] and then remember to escape and enquote it before submitting to the database.

 

[filipel]

Ok.Thanks .But what datatype should i refer in mysql?Integer?

 

[vacunita]

That would depend on what you are storing. if you are storing whether they are checked or not use a Boolean, if you want the actual value, either string or Integer depending on what is going to be stored.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.