It's not the checkbox's VALUE attribute that determines whether it is checked or not. If you add the empty attribute CHECKED, then the checkbox will be checked.
Example: <INPUT TYPE='Checkbox' NAME='VarCheck1' VALUE='Good' CHECKED> <INPUT TYPE='Checkbox' NAME='VarCheck2' VALUE='Good'> VarCheck1 will be checked, and VarCheck2 will not be checked. A checkbox will only have a value on submission IF IT IS CHECKED. So if the above two boxes were submitted and VarCheck1 was checked and VarCheck2 was not checked, the new page would have the variable VarCheck1 containing "Good", while VarCheck2 would be empty/non-existent. - Jonathan -----Original Message----- From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 8:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Checkboxes, PHP, and MySQL I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. Here's what I am doing: I have a form with a few checkboxes. When the information as to whether the checkboxes are checked or not is 'saved' into the MySQL table, they are represented by a value of '1' - fine. When I want to edit this information, in the form of a similar form with checkboxes, the boxes are not checked off if they were before. What I am stuck on is how a checkbox can get checked off when pulling information from the MySQL as an array. Here's a line of code showing my array coming out. <input type=checkbox name=firstvalue value='$result[32]'> $result is the array. I guess what I am asking is that if a checkbox is assigned a value of one, why doesn't it appear as already checked off? Thanks, -Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
