Using MySQL Field Data for Check Box

[saltious]

Hi.

i would like to be able to use a value pulled from a field in the sql table to dictate whether a check box is checked on a HTML form.

i would also like it so that this can then be unchecked and when the update button is pressed the changed value can be passed / updated to the table.

anyone have any ideas?

many thanks.

[Ilyes]

This is possible.
Load value from the Db and save it in variable $state .
then in your page:

<form id="form1" name="form1" method="post" action="">
  <label>
  <input name="checkbox" type="checkbox" value="checkbox" <?php if ($state==true){echo ' checked="checked" ';} ?> />
    label</label>
	<br />
  <input type="submit" name="Submit" value="Submit" />
</form>

then create a script in a second php page to update DB with value of the checkbox when "submit" button is clicked

[saltious]

Hi Thanks for this. i think its nearly there.

the only thing is that no matter what it sets to checked. In the table the field is either set to "Open" or "Closed". how do i tell it elseif = "Open"... dont check it?

many thanks.