INSERTING RADIO BUTTON VALUE - MYSQL

[michael1291]

Hi, just wondering if anyone knows how to insert the value of a radio button to mysql and then when the page is refreshed it will display the radio button that was selected still.

 

 

THANKS in advance for any help.

[The Little Guy]

<?php
if(isset($_POST['submit']){
    $rdo = mysql_real_escape_string($_POST['radioButton']);
    mysql_query("insert into my_table (radioBtn) values ('$rdo')");
    // Redirect so we don't double post
    header("Location: {$_SERVER['PHP_SELF']}");
    exit;
}
$sql = mysql_query("select * from my_table");
$row = mysql_fetch_assoc($sql);
$checked = $row['checked'];
?>
<form action="" method="post">
<input type="radio" name="radioButton" value="value1" <?php ($checked == "value1"?'checked="checked"':'') ?> /> Value1<br />
<input type="radio" name="radioButton" value="value2" <?php ($checked == "value2"?'checked="checked"':'') ?> /> Value2<br />
</form>