lkpchecks.blogg.se

print_r for the select qry displays in part The checkbox fields are set to varchar(5). I changed TRUE/FALSE in the source table to 1,0. The sql statement is `$sql = “UPDATE AAUW_Members SET FirstName = ‘$_POST’,LastName = ‘$_POST’,Address1 = ‘$_POST’,City = ‘$_POST’,State = So when the input field is text, the $_POST correctly attempts to input a string value, but when the input field is a checkbox, the AllThoseBooks = ‘$_POST’, is attempting to input AllThoseBooks rather than the boolean 1, hence the input statement fails? The form-handler displays the $sql update asĬonnected Successfully5293479UPDATE AAUW_Members SET FirstName = ‘Claudette’,LastName = ‘Hennessy’,Address1 = ’20 Dutchess Landing Road, Apt B211′,City = ‘Poughkeepsie’,State = ‘NY’, Zip = ‘12601’,HomePhone = ‘n/a’,……., AllThoseBooks = ‘AllThoseBooks’, ‘WorldTravelers’ WHERE ID = ‘5293479’ Not updated $sql = “UPDATE AAUW_Members SET FirstName = ‘$_POST’,LastName = ‘$_POST’,Address1 = ‘$_POST’,City = ‘$_POST’,State =

Is inserting the values as tricky as displaying them? Can I just