followed auroral for insert,update, delete record can't get it to work

unable to get records to inset or update corrects, I cannot see whats wrong please c an you help

i thought yh update would populate the form WITh the current data fo=rom the database initially

What is the data type for the checkbox controlled columns?

One way to debug what is going on is to dump the query object after the insert takes place. Add this code below the insert code:

<?php

if ($_SERVER["REQUEST_METHOD"] == "POST") {

  var_dump($InsertQuery);

  die();

|

?>

Then post that result here and I can diagnose what might be going wrong.

nb working on localhost
the fields holding checkboxes are defined in db as one character tying to store y or n

It looks like that insert worked. There are no errors and everything seems to be in place.

What is the problem you are having?

insert 3 y's regardless how many specified

update doesn't popular form wit current rect as i believe it should .... how do u know what changes to make
the u make change press submit it baks out the site the check boxes stay the same

Try replacing the queryobj.php file with the one I have attached.

status quo prevail ... results same, created front end so i donut chabg4 anything only the front end .

copied over file now see a message with the dum not seen b4, dump in pm

have i got my thought proved + logic wrong

to update a record first of all you need to see the original data, loaded into the form from database , then you make the chances the data base record is rewetted with all titre fieds again ... including the ons changed.

input - fill in form results in the record being written but all the check boxes set to y ... database default is null

update no original data presented in the form , make changes blind no change to db



can you please confirm my logic iS correct before i go mad

The logic looks correct to me. Can I get FTP access and a URL to reproduce? I'll be able to debug and find the solution that way. It must be an issue in the way the checkbox Y/N code is set up.

see pm

The queryobj.php file wasn't updated on your live server. I updated it and it seems to have fixed this problem.