I have the following table/fields :
name int(4) NOT NULL auto_increment,
bl_name varchar(90) NOT NULL default '',
bl_address varchar(90) NOT NULL default '',
bl_zip varchar(15) NOT NULL default '',
bl_phone varchar(30) NOT NULL default '',
bl_www varchar(15) NOT NULL default '',
notes text NOT NULL,
PRIMARY KEY (name);
entering the data below formatted as is works fine ... it enters the the specific data into the correct fields...
RCH ;
business name ;
street address ;
zip code ;phone ;
www address ;
...PLEASE tell me how I can insert multiple (seperate) rows from the same text file...? i.e.,
RCH ;
business name ;
street address ;
zip code ;phone ;
www address ;
RCH;
business name ;
street address ;
zip code ;phone ;
www address ;
RCH ;
business name ;
street address ;
zip code ;phone ;
www address ;
etc
etc
etc Thanks to anyone that can help...
Richard
