delete check colum

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
alfredonan
Forum Newbie
Posts: 1
Joined: Wed Feb 27, 2008 9:48 am

delete check colum

Post by alfredonan »

i will be glad if i could be given any advice or example coding to delete a column from a table
eg this is the table
unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <somedatat> <somedata> <somedata>


some if fieldcolumn1 is checked with a checkbox only that part should be deleted from the table without affecting the rest. more fields could be checked as well.

so the resulting table will look like:

unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <deleted from table> <somedata> <somedata>


thank you
User avatar
hawkenterprises
Forum Commoner
Posts: 54
Joined: Thu Feb 28, 2008 9:56 pm
Location: gresham,oregon
Contact:

Re: delete check colum

Post by hawkenterprises »

ALTER TABLE table_name
ADD column_name datatype

ALTER TABLE table_name
DROP COLUMN column_name

Taken from w3schools.com
Post Reply