Check Box

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?

Something like this:

PHP Code:

---

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

---