Checkbox – auto form submit?

Hi,

I have the following part of a script:

[code=php] if ($row[‘9’] == ‘Y’) {
echo ‘<input type=”checkbox” name=”approved” value=”Y” checked />’;
}
else {
echo ‘<input type=”checkbox” name=”approved” value=”Y” />’;
}
[/code]

Now this displays a checked checkbox when the value equals ‘Y’ and unchecked if it’s anything else.

Now I wonder, is it easy to set an auto-submit on this checkbox so if its unchecked it does an automatic UPDATE query to make a value equal to ‘N’.
Or if it’s checked, to make it ‘Y’ if checked.

Thanks for any help.

Also in #PHP _↴