Checkboxes

[jhlew]

Hi, I have a form that has a checkbox in it. When the checkbox is clicked a 1 is saved in my database. I would like the user to be able to see that checkbox checked every time they login. I know how to display the checkbox as checked but is there a way to display the checkbox as checked only if there is a 1 in the database.

here is my current code.

$r1a=0;

if (isset($_POST["r1a"])) {
$r1a=1; 
 $sqlUpdate = mysql_query("UPDATE finances SET r1a='$r1a' WHERE mem_id='$id'");
}

<form action="Finances.php" enctype="multipart/form-data" method="post" name="checkform" id="checkform">
<input type="checkbox" name="r1a" value="1"/>
<input type="submit" name="button1" id="button1" value="Submit" /></form>

[bradgrafelman]

Retrieve the value from the database and, if it is a '1', then output the appropriate HTML (e.g. checked="checked").

[jhlew]

can i add that code to the code that i have right now that inputs a 1 into the database.

[bradgrafelman]

jhlew;10985467 wrote:

can i add that code to the code that i have right now that inputs a 1 into the database.

You tell me; is that the same code that outputs the HTML for the checkbox? If yes, then yes. If no, then no.

[jhlew]

yes it is. but if i put checked="checked" in the html then it automatically checks the box.

[bradgrafelman]

Right.. that's why I said you first need to:

bradgrafelman wrote:

Retrieve the value from the database

so that you can determine whether or not you should output that or not.

[jhlew]

well i cant figure out exactly how to do that. thanks anyways.

[bradgrafelman]

Have you tried?

Whenever they login, you'd just run a SELECT query to retrieve that value from the DB. Then, you'd check to see if that value is '1' and, if so, output that checked="checked" string inside the checkbox's tag. If it isn't 1, don't output that extra attribute.