So a checkbox field (logical field) should always be numeric? Either a '1' or a '0' ?
Could you make a checkbox function correctly with updating records with that field being a CHAR(1)?
<?php
if ($row_WADAgallery['status'] == 'Y') {
?>
<td>Disable</td><td><input name="status" type="checkbox" value="N"></td>
<?php
} else {
?>
<td>Make Live!</td><td><input name="status" type="checkbox" value="Y"></td>
<?php
}
?>
The above isn't working correctly. The value already stored is getting changed to the opposite on every update save. This requires an additional separate update to change the original setting back to the correct state.
What am I doing wrong here?
Thanks!