alter table errors from mysql

Hi I am having problems with a script I wrote awhile ago but now is popping up errors when it gets to altering a table.

I checked the user priv for this user and then do have Alter_priv in the mysql.user table.

before it runs i have it print out the sql statement so i try just copying that and typing that in the mysql client and it runs fine.

thanks for any help

jake

I guess I should be a little more clear, and hopefully someone can help me out.

but this is what I run for a alter command that keeps giving me errors:

here is the command that I have printed out:

ALTER TABLE $cdbname.$tablename ADD $colName $sqlType

which results in something like this

ALTER TABLE Customer.new_form CHANGE name_ varchar(150)

which it then dies at but if i log into the web server and then connect to the db server using the mysql client and run the command it runs fine.

I would appreciate any advice at all

jake

Sorry mis-type it spits out:

ALTER TABLE Customer.new_form ADD name_ varchar(150)

My problem was that i was running php with the generic mysql modules,

if anyone else runs into this problem

jake