Checkbox and updating to mySQL

kilbey1

After some help, I got this code to work that tests which checkboxes are checked and updates my field appropriately in mySQL (field: active, value 0). What I am now trying to figure out is how to update when a box is NOT checked and enter another value (1) into the same mySQL field through the update statement. Anyone know how this goes? I've got this code running:

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

	for ($i=0; $i<count($categories); $i++) {
 		$key = $categories[$i];
		# Create the Query.
		$sql = "UPDATE categories SET active='0'";
		//$result = mysql_query ($sql);
		echo "$sql - ";
		echo "Record $key is checked!<br /><br />";

		# Get Ready to Run the Query
		//$ok = mysql_query ($sql);
	}
		# UPDATE does not return records
		# But we can verify the update
		if ( !$ok ) { echo "<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b><font color=\"red\">Did not update record</font></b>"; }
		else { echo "<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B>Record updated.</B><BR>"; }
}

diego25

You could create an array with all the checkboxes names. Then use array_diff to compare that array with $checkboxes. That will give you the checkboxes that weren't clicked, so you use another for-loop to add that to your SQL statement.

Diego

kilbey1

Hmm, seems to be checking just the checked boxes and not all of them. I'm not very good with arrays, I'm afraid.

kilbey1

* BUMP **

kilbey1

For those requiring the same solution, I solved this by setting all fields to 0 and switching logic around somewhat (0 = off, 1 = on).

It's WAY easier to check for checked boxes than the empty ones.

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

		$sql = "UPDATE categories SET active='0'";
		mysql_query($sql);

	for ($i=0; $i<count($categories); $i++) {

 		$key = $categories[$i];
		echo "Record $key is checked!<BR />";
		mysql_query ("UPDATE categories SET active='1' WHERE product_name_id='$key'");

	}

}