adding checkbox data back into DB

kilbey1

Ok, I'm not finding this. I can populate checkboxes, run while loops, all sorts of lovely stuff.

Now, can someone please give me an example of determining the checkbox state (so I can enter the new state into field "active")? Active = 0, not active = 1, with checkbox names being "categories[]"

Here is what I've started:

if ($HTTP_POST_VARS[Submit]) { // Update the product

$sql="select active	FROM categories";
$result=mysql_query ($sql);

while ($row = mysql_fetch_array($result)) {

//	if (isset($categories)) { 

		if ($categories=="checked") {
			$categories = 0;
			echo "checked<BR>"; 
		} else { 
			$categories = 1; 
			echo "not checked<BR>"; 
		}	

//	}

}

}

bastien

from your code i can't seem to figure out which way you are going...are you looking to create checkboxes with the states(1 or 0) from the data in the table?

kilbey1

Nah. The checkboxes are already created and populated. Now I want to let a user check/uncheck a checkbox, and when they hit SUBMIT, that'll update the 'active' field in the DB with 0 (checked) or 1 (not checked).

-Eve

bastien

checkboxes that are checked show on and the ones that are not checked are blank

test this by passing the data through the URL using the get method and you'll see what i mean

intenz

Try...

<?
if( $_POST['submit'] )
{
	if( $_POST['checkbox'] == 'on' )
		$check = 1;
	else
		$check = 0;

update query...
}
?>