sorry if this is considered a noob question, but i have only just started to learn about sql and php.
I am using phpmyadmin on a remote server to import a sql file which will make some table and import some information.
so far I have the following to make the tables
so I have 2 questions.Code:CREATE TABLE IF NOT EXISTS `est_costcenters` ( `est_ccorder` int(11) NOT NULL auto_increment, `est_cccode` varchar(100) NOT NULL default '', `est_ccname` varchar(100) default '', `est_ccgl` varchar(100) default '', `est_ccsubgroup` varchar(100) default '', `est_ccsecret` varchar(100) default '', PRIMARY KEY (`est_ccorder`) ) TYPE=MyISAM;
- can i get it to check if the fields exist and create them if they dont ?
- Can someone show me the code to include information in the fields, the original information is in an access database, but i export to txt csv etc.
Thanks.


Reply With Quote



Bookmarks