Update database by checkboxes

[only1perky]

Hi guys,

 

I'm trying to update my database with a certain number of checkboxes.

At the moment I have this in my form:

 

<input name="mailinglist" type="checkbox" id="mailinglist" value="1" <? if($row_rsdetails['mailinglist'] == 1){ ?> checked="checked" <? } ?>/>

 

This works and updates the database with the value 1 when checked. What I can't figure out is how to update the database with 0 if the box is unchecked.

 

I'm sure this is glaringly obvious but I'm stumped.

 

Cheers.

[s0c0]

If the POST variable is not set, then set it to 0 as the box was not checked.  This should do it.

 

if(!isset($_POST['mailinglist'])){
	$_POST['mailinglist']=0;
}