SQL Table
CREATE TABLE tblEuthanizeRates(
pmkDogId INT AUTO_INCREMENT PRIMARY KEY,
fldPetType VARCHAR(15),
fldNumInShelters VARCHAR(10),
fldNumEuthanized VARCHAR(10),
fldPercentEuthanized VARCHAR(10)
)
Insert Statement
INSERT INTO tblEuthanizeRates (fldPetType, fldNumInShelters, fldNumEuthanized, fldPercentEuthanized)
VALUES (
"Cats & Dogs", "6.5 Mil", "1.5 Mil", "23%"),
(
"Cats", "3.2 Mil", "860,000", "27%"),
(
"Dogs", "3.3 Mil", "670,000", "20%"
)
Select Query
$sql = 'SELECT fldPetType, fldNumInShelters, fldNumEuthanized, fldPercentEuthanized FROM tblEuthanizeRates';
SQL Form Table
CREATE TABLE tblDogForm (
pmkDogFormUserId INT AUTO_INCREMENT PRIMARY KEY,
fldFirstName VARCHAR(30),
fldLastName VARCHAR(30),
fldEmail VARCHAR(50),
fldDogGender VARCHAR(14),
fldPreferredDogBreed VARCHAR(19),
fldRecieveEmails TINYINT(1),
fldRecieveDogs TINYINT(1),
fldSendMoney TINYINT(1),
fldComments TEXT
)
Form Insert Statement
INSERT INTO tblDogForm
(fldFirstName, fldLastName, fldEmail, fldDogGender, fldPreferredDogBreed, fldRecieveEmails, fldRecieveDogs, fldSendMoney, fldComments)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)