SQL

Create table

        CREATE TABLE tblDolomites(
            pmkDolomitesId INT AUTO_INCREMENT PRIMARY KEY,
            fldRoute varchar(30),
            fldDistance varchar(5),
            fldDuration varchar(10),
            fldDifficulty varchar(18),
            fldStart varchar(30),
            fldEnd varchar(30)
        )
        
    

Insert Data

    INSERT INTO tblDolomites (fldRoute, fldDistance, fldDuration fldDifficulty fldStart fldEnd) 
    VALUES ('Seiser Alm - Rosengarten', '38.5 miles', '5 - 7 days', 'Moderate', 'Val Gardena', 'Val di Fassa')
    

Select Records

        SELECT fldRoute, fldDistance, fldDuration fldDifficulty fldStart fldEnd FROM tblDolomites
    

Create Form Table

        CREATE TABLE tblPreferences (
            pmkPreferences int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
            fldDolomites tinyint(1) DEFAULT 0,
            fldChamonix tinyint(1) DEFAULT 0,
            fldKilimanjaro tinyint(1) DEFAULT 0,
            fldOther tinyint(1) DEFAULT 0,
            fldExperience varchar(15) DEFAULT NULL,
            fldFirstName varchar(30) DEFAULT NULL,
            fldLastName	varchar(30) DEFAULT NULL,
            fldEmail varchar(50) DEFAULT NULL
        )
    

Insert Data

        INSERT INTO tblPreferences
        (fldDolomites, fldChamonix, fldKilimanjaro, fldOther, fldExperience, fldFirstName, fldLastName, fldEmail)
        VALUES(1, 1, 0, 0, 'Beginner', 'Corinna', 'Kelly', 'corinna.kelly@uvm.edu');