storing checkbox to db

[true2self]

Hi,

 

The if statement does work properly, it goes through each entry and posts the id# and whether its a 1 or 0. But when I try to update the datebase it is not working. Can someone please help me out?

 

    if (isset ($_POST['isx2_'][$id])){
                            $isx2 = 1;
                            echo "ID ".$id."is set to 1"; 
                            echo "</br>"; 
                            $sql = "UPDATE" . $CFG->prefix . "grades_contentareas_stdt SET isx2=". $isx2 . "where userid =".$id;
                            $rs = $db->Execute($sql);
                 }  else   {
                             $isx2 = 0;
                             echo "ID ".$id."is set to 0"; 
                             echo "</br>" ; 
                             $sql = "UPDATE" . $CFG->prefix . "grades_contentareas_stdt SET isx23=".$isx2." where userid =".$id;  
                             $rs = $db->Execute($sql);
                             }

[sasa]

try to add space after "UPDATE" , change to "UPDATE "

in 2nd $sql you have field name isx23

[true2self]

Thank you. that worked!! (well and a space was needed before the "where" in the first update, but you got me on the right track.)

[Barand]

When you have problems with a query it's often a good idea to echo it and do a visual syntax check and to see if all the variables' values are present as expected