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 (?, ?, ?, ?, ?, ?, ?, ?, ?)