ok i need help i have a page i have coded and i have made a newer version and added collums to the table how would i go about comparing the 2 tables colums and adding the missing collums to a array to be used in an alter table query this is the old structure [code] CREATE TABLE `tablename` `id` int(11) NOT NULL auto_increment, `file` varchar(255) NOT NULL default '', `caption` varchar(255) NOT NULL default '', `ext` varchar(255) NOT NULL default '', `catagory` varchar(255) NOT NULL default '', `approve` varchar(3) NOT NULL default '', PRIMARY KEY (`id`) ) [/code] and this si the new one [code] CREATE TABLE `".ROSTER_SCREENTABLE."` ( `id` int(11) NOT NULL auto_increment, `file` varchar(255) NOT NULL default '', `caption` varchar(255) NOT NULL default '', `ext` varchar(255) NOT NULL default '', `catagory` varchar(255) NOT NULL default '', `approve` varchar(3) NOT NULL default '', `votes` varchar(10) NOT NULL default '', `rateing` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ) [/code] any help guys