Create table
CREATE TABLE tblSammyJ (
pmkSammyJId int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldfirstName varchar(20) DEFAULT NULL,
fldlastName varchar(20) DEFAULT NULL,
fldEmail varchar(50) DEFAULT NULL,
fldEnjoy varchar(15) DEFAULT NULL,
fldFlagrant tinyint(1) DEFAULT 0,
fldTwoTimesFire tinyint(1) DEFAULT 0,
fldSJRadio tinyint(1) DEFAULT 0,
fldDinnerTime tinyint(1) DEFAULT 0,
fldSubject varchar(70) DEFAULT NULL
)
CREATE TABLE tblUpcomingGuest (
pmkGuestId int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldGuestFirst varchar(20) DEFAULT NULL,
fldGuestLast varchar(20) DEFAULT NULL,
fldTopic varchar(50) DEFAULT NULL,
fldDate varchar(15) DEFAULT NULL,
fldOccupation varchar(20) DEFAULT NULL
)
Insert
$sql = 'INSERT INTO tblSammyJ (fldfirstName, fldlastName, fldEmail, fldEnjoy, fldFlagrant, fldTwoTimesFire, fldSJRadio, fldDinnerTime, fldSubject)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)';
INSERT INTO tblUpcomingGuest (fldGuestFirst, fldGuestLast, fldTopic, fldDate, fldOccupation) VALUES
('Sara','Ivry','How to survive in the podcast/journalism industry','Dec-29','freelance journalist'),
('Mike','Tyson','Conquering aggression and finding zen','Jan-20','former boxer'),
('Amy','Adams','Enchanted by Amy; Sam discusses with Amy Adams','Sept-20','actress'),
('Bernie' ,'Sanders','Vermont: economy, agriculture, and homogeneity','Jun-12','Senator'),
('Miro','Weinberger','Burlington and dealing with homelessness','Feb-18','Mayor')
Select records
SELECT fldfirstName, fldlastName, fldEmail, fldEnjoy, fldFlagrant, fldTwoTimesFire, fldSJRadio, fldDinnerTime, fldSubject