Checkboxes, databases and array, unchecked troubles!

[emma_1986]

Hey guys, just wondered if anyone could help please. I am new to php. I am trying to update by database so that if any check boxes are checked then update to 'yes' and the check boxes that were not checked to update to 'no' .

my code for creating the check boxes is:

 

print "<td align = \"CENTER\" bgcolor=\"$color\">" . "<input type=\"checkbox\"  name=\"fchk1[]\"  value=\"$doc_no\" echo '$checked' >

 

and my code for the action page is:

if(isset($_POST['update'])) {

$fchk1=$_POST['fchk1'];

if (is_array($fchk1)){

      foreach ($fchk1 as $doc_no){

    $update_query = "UPDATE uploads u SET u.saccess = 'yes' WHERE  u.doc_no = '$doc_no'";

    $result = $db->query($update_query);

    //$db->disconnect();

    header("Location: main.php?target=docs&type=h");

            }

}

else {

 

$update_query = "UPDATE uploads SET saccess = 'no'";

$result = $db->query($update_query);

//$db->disconnect();

header("Location: main.php?target=docs&type=h");

}

}

the checked part works fine, but the unchecked part does not work unless there is no checked boxes.

 

Kind Regards Emma

 

[Yesideez]

Welcome!

 

If you modify your post quickly and surround your code with CODE tags it'll be more readable.