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']
dBforums
>
Getting stuck on ALTER...
03-07-06, 23:54
Linear Mode
