Welcome to Halloweentown

the best halloween movies, past and present

Create Table SQL

CREATE TABLE tblMovieForm(
    pmkMovieFormID INT AUTO_INCREMENT PRIMARY KEY,
    fldFirst VARCHAR(30),
    fldEmail VARCHAR(30),
    fldTitle VARCHAR(50),
    fldFamily TINYINT(1),
    fldKids TINYINT(1),
    fldHorror TINYINT(1),
    fldClassic TINYINT(1),
    fldModern TINYINT(1),
    fldRate VARCHAR(30),
    fldComments TEXT
);

Insert Table Data SQL

INSERT INTO tblMovieForm(fldFirst, fldEmail, fldTitle, fldFamily, fldKids, fldHorror, fldClassic, fldModern, fldIssue, fldComments) VALUES
('Stephanie Godes', 'sgodes@uvm.edu', '1', '1', '0', '0', '0', '1 star', 'hello');