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