Thanks Rick. The 1st script worked just fine. The 2nd script gave me a SQL error. Here is the response:

Quote
Script: /...../dodbcommand.php
Line#: 101
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(3) not null default 'yes', change USER_ACCEPT_PM varchar(3) not null de' at line 2
SQL Error #: 1064
Query: alter table ubbt_USER_PROFILE change USER_NOTIFY_ON_PM varchar(3) not null default 'yes', change USER_ACCEPT_PM varchar(3) not null default 'yes'