Checkbox updating database

[cronThis]

How can I get a checkbox form to change a value in a table?  For example, I just want a value changed from a 0 to a 1 based on whether someone checked off if something has been accepted of unaccepted.

[pocobueno1388]

<?php

if (isset($_POST['check'])){
   //The checkbox was checked, update the database
   $query = mysql_query("UPDATE table SET field=1 WHERE fieldID='$some_var'")or die(mysql_error());
}

?>

<form>
   <input type="checkbox" name="check">
   <input type="submit" name="submit">
</form>

[unidox]

Here:

 

<?
if ($_POST) {
$name = $_POST['name'];
if ($name != 0) {
$name = 1;
else {
$name = 0;
}
} else {
?>
<form action="#" method="POST">
<input name="name" type="checkbox">
<input type="submit">
</form>
<?
}
?>

 

Then just add you query to inset/update