Checkbox failing to show correct retrieved value
I have a checkbox on an Update page created with DA.
When the checkbox is ticked the value 1 is saved to MySQL ok.
When unticked, a value of 0 is saved. All good there
However, on returning to the form after an update, the check box is failing to show checked or unchecked, according the the value saved in MySQL record.
Instead it shows checked even when the MySQL value is = 0.
Here is the checkbox code;
My other radio, drop down and text fields retrieve and show the value as expected.