Check Box

[kiwis]

HI All,

I have a feild in my SQL table which has either a value of 0 or 1
I want my code to change my text box from not ticked if 0 and ticked if the value is 1.

any idea what the code would be?

[visualAd]

Something like this:
<input type="checkbox" <?php if ($field): ?>checked="checked"<?php endif; ?> />