Checkboxes help

[tjg73]

Perhaps this is an HTML question but since my question relates to MySQL I am thinking it is more PHP.  I really need help figuring out how change the status of a checkbox from not checked to checked based on its value in the database.  In the database the checkbox column says "YES"  (that it has been checked)  When the page is visited at a later date, I need to pull that value from the database and have that checkbox now CHECKED.  Did this make sense?  Can anyone help?

 

thanks

 

[sureshp]

Try this:

========

 

$checked = ($database_value == "YES") ? "checked" : "";

 

Use this $checked variable in the checkbox html tag as like below:

<input type='checkbox'  name='something' value='somethingsomething' $checked>