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';