help with checkbox fields

[aron]

this is the code.

what im trying to do is if it checked then the value is 1 else the value is 0

<input name="tiled_roof" type="checkbox" id="tiled_roof" <? if($line["tiled_roof"] == 1){echo 'checked value="1"';} else {'value="0"';}?>>

cheers aron.

[aron]

with the code below

$sql = "UPDATE property SET $sql_2 date='$tdate' WHERE id=$id" or die("Invalid query: " . mysql_error());
echo $sql;
mysql_query($sql) or die("Invalid query: " . mysql_error());
?>
<script type="text/javascript" language="javascript">
<!--
location.replace('step4_com.php?id=<? echo $id ?>');
-->
</script>

if i remove the script at the botom it works (the database gets updated) if i leave it in its like its not getting enough time to update anyotherway around this

[devinemke]

unchecked checkboxes are not returned to the form processor so there is little point in conditionaly setting the checkbox's value. just do:

<input name="tiled_roof" type="checkbox" id="tiled_roof" value="1">

then in your form processor:

if (isset($_POST['tiled_roof']))
{
	// yes, it was checked
}
else
{
	// no, it was not checked
}