I appreciate your help in advance.

I need to update and rename a column name given from a '$_POST' var. At times I will also need to ADD a column name. You may either post a URL for good instructions, or tell me how so. I am not sure what version of MySQL we are running at work though ... we have PHP5 so I am guesssing we have latest version of MySQL too.

I am using this syntax:

PHP Code:
ALTER TABLE staff CHANGE COLUMN address $_POST['var'int(11
AND

PHP Code:
ALTER TABLE staff ADD COLUMN $_POST['var'