Table

CREATE TABLE tblDietVariationsandResults(

pmkDietVariationsandResultsid INT AUTO_INCREMENT PRIMARY KEY,
fldDietQuality VARCHAR(125),
fldEffects VARCHAR(107),
fldLongTermImpacts VARCHAR(100)
tenured BOOLEAN
);

Form Table

CREATE TABLE tblformpage(
pmkformselects INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldEmail VARCHAR(50) DEFAULT NULL,
fldChkbettereducated tinyint(1) DEFAULT 0,
fldChkknowmore tinyint(1) DEFAULT 0,
fldChkconfused tinyint(1) Default 0,
fldRadio VARCHAR(100) DEFAULT NULL)

    'INSERT INTO tblformpage
    (pmkformselects, fldEmail, fldChkbettereducated, fldChkknowmore, fldChkconfused, fldRadio)
    VALUES
    (1, gpeck2@uvm.edu, 0, 1, 0, 1)';