Here’s a sample of what I have that is working. The field names are followed by 2 sets of VALUES each enclosed in () and separated by a comma and all terminated by a semicolon. I’m disguising the true contact info.
INSERT INTO `doctors` (`doctor_class`,`primary_specialty`,`secondary_specialty`,`first_name`,`last_name`,`state`,`email`,`primary_phone`,`alt_phone`,`fax`,`street_address_1`,`street_address_2`,`city`,`zipcode`,`major_activity`,`facility`,`status`) VALUES ("x_test_data_only", "Dermatology", "", "Anita", "", "FL", "x@yahoo.com", "1112223333", "", "1112223333", "7125 Main Rd", "", "Somecity", "12345", "", "", "Active"),("x_test_data_only", "Allergy Immunology", "", "Gabriel", "Smith", "TX", "xx@yahoo.com", "1112223333", "1112223333", "1112223333", "123 Main St", "", "Smalltown", "12345", "", "", "Active");I can’t find the exact code that was not working but it’s 10 of these for testing. Each terminated with a semicolon. Here is a recreation. Note that I’ve tried various ways to enclose table name, field names, and data in " or ’ or or nothing. [code]INSERT INTOdoctors (doctor_class,primary_specialty,secondary_specialty,first_name,last_name,state,email,primary_phone,alt_phone,fax,street_address_1,street_address_2,city,zipcode,major_activity,facility,status) VALUES ("x_test_data_only", "Allergy Immunology", "", "amy", "smith", "NY", "xx@usa.net", "", "", "", "123 Main St", "", "New York", "10028", "", "", "Active");INSERT INTO doctors (doctor_class,primary_specialty,secondary_specialty,first_name,last_name,state,email,primary_phone,alt_phone,fax,street_address_1,street_address_2,city,zipcode,major_activity,facility,status`) VALUES (“x_test_data_only”, “Allergy Immunology”, “”, “amy”, “smith”, “NY”, “xx@usa.net”, “”, “”, “”, “123 Main St”, “”, “New York”, “10028”, “”, “”, “Active”);[/code]