Create Dynasties Table

CREATE TABLE tblDynasties( 
    pmkRulingDynasties INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldDynasty VARCHAR(50), 
    fldYears VARCHAR(50)  
)

Insert Values Into Dynasties Table

INSERT INTO tblDynasties
(fldDynasty, fldYears)
VALUES
("Xia Dynasty unconfirmed", "2100-1600 B.C."),
("Shang Dynasty", "1600-1050 B.C."),
("Zhou Dynasty", "1050-256 B.C."),
("Qin Dynasty", "221-206 B.C."), 
("Han Dynasty", "206 B.C.-220 A.D."),
("Six Dynasties", "220-589 A.D."),
("Sui Dynasty", "581-618"),
("Tang Dynasty", "618-906"),
("Five Dynasties", "907-960"),
("Liao Dynasty", "907-1125"),
("Song Dynasty", "960-1279"), 
("Yuan Dynasty", "1279-1368"), 
("Ming Dynasty", "1368-1644"),
("Qing Dynasty", "1644-1911") 

Select From Dynasties Table

SELECT fldDynasty, fldYears FROM tblGoals

Create Table for Form Responses

CREATE TABLE tblChinaFeedback(
    pmkChinaSurveyId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldFirstName VARCHAR(30) DEFAULT NULL, 
    fldLastName VARCHAR(30) DEFAULT NULL, 
    fldEmail VARCHAR(50) DEFAULT NULL,  
    fldVisit TINYINT(1) DEFAULT 0, 
    fldNotVisit TINYINT(1) DEFAULT 0, 
    fldVisited TINYINT(1) DEFAULT 0, 
    fldMaybeVisit TINYINT(1) DEFAULT 0, 
    fldMaybeVisited TINYINT(1) DEFAULT 0, 
    fldKnowledge VARCHAR(15) DEFAULT NULL 
)

Insert User's Form Responses Into Table

INSERT INTO tblChinaFeedback
    (fldFirstName, fldLastName, fldEmail, fldVisit, fldNotVisit, fldVisited, fldMaybeVisit, fldMaybeVisited, fldKnowledge)
    VALUES
    (?, ?, ?, ?, ?, ?, ?, ?, ?);