delete checkbox from database

[alfredonana]

i would be glad if i can get some help or advice on php query code use to delete a checked column from a database.
for example if i have the table below

field 1 field 2 field 3 field 4
1111 kofi ddd cae

field i contains a unique id and if field 2 or field 3 is checked it should be able to delete only that column into a new table so that field 1 and field 4 will be left.
the new table should look like this:

field 1 field 2 field 3 field 4
1111 <deleted> <deleted> cae

i am counting on you help and it is urgent. thank you.

[jeremyphphaven]

my suggestion... Field 2 and 3 should be tinyint(1) fields that you set in your database to 1 (ON) or 0 (OFF) with 0 being the default.

then just make a php script to do whatever you need to do with that.

So if each user says I live in CALIFORNIA or not... on the front end they check a box, select yes or no, whatever the case may be, and you recorde that as a one or zero in the DB

make sense?

-cheers!

[alfredonana]

thank you for the information, but what i want to do is after the box has been checked, those checked boxes should be deleted and as well posted to a new table. if you could help me with some code i be very much grateful since i am just a starter to php. hoping to hear from you soon

[alfredonana]

thank you for the information, but what i want to do is after the box has been checked, those checked boxes should be deleted and as well posted to a new table. if you could help me with some code i be very much grateful since i am just a starter to php. hoping to hear from you soon

[jeremyphphaven]

so you want to remove those fields from the front-end. create a new table in the back-end and update some flag to show yes/no. 3 tasks, correct?

[alfredonana]

yes, delete checked box from front end but id and other unchecked field and post them into a back end table. thankx

[alfredonana]

hello
what i want to do is i sql select statement to select drugs prescribed by a doctor against checkboxes probably 6 or more prescribed by a doctor to a patient. so if a pharmacist enters the patient id all prescribed drugs will be shown against a checkbox and patient id. so if pharmacist is able to supply 1 or more of the prescribe drugs that checked drug should be deleted from the frontend and entered into a new table as a backend. can you help me with coding and advice. i will be much greatful

for example if i have the table below( as front end)

field1 field2 field3 f ield4
1111 para dewormer vitamin c

field i contains a unique id and if field 2 or field 3 is checked it should be able to delete only that column into a new table so that field 1 and field 4 will be left.
the new table should look like this🙁now the front end)

field1 field2 field3 field4
1111 <deleted> <deleted> vitamin c

And the two deleted drugs will be sent into a new table as backend etc