//include 'connect4.inc';
//include '../modules/db.php';
$categorys = [
['Landscape Lighting', 'LL', 13731],
['Pavers, Masonry, Blocks & Rocks', 'PMBR', 13734],
['Water Features', 'DWF', 13726],
['Plant Materials', 'PM', 13736],
['Plant Accessories', 'PA', 13735],
['Turf & Ornamental', 'TO', 13739],
['Outdoor Living', 'OL', 13732],
['Park and Recreation', 'PR', 13733],
['Site Amenities', 'SA', 13737],
['Green Roof', 'GR', 13730],
['Water Management / Irrigation', 'WMI', 13740],
['Stormwater/Erosion Control', 'SEC', 13738],
['Business Services', 'BS', 13725],
['Equipment - Installation', 'EQI', 13727],
['Equipment - Maintenance', 'EQM', 13728],
['Equipment - Parts & Repair', 'EQPR', 13729],
];
foreach($categorys as $index){
$catName = $index[0];
$catAbbrev = $index[1];
$catNum = $index[2];
$sql = "SELECT * FROM ylist WHERE idParent = " . $catNum . " AND prod_info = 0 ORDER BY name";
$result = $conn->query($sql);
$numOfRows = mysqli_num_rows($result);
echo '
';
echo '';
echo '';
echo '
';
while($row = mysqli_fetch_array($result)) {
$id = $row['sub_number'];
echo '
';
}
echo '
';
}
?>