Waterfalls, Fish Ponds, Fish Pond Kits, Waterscaping, Water Features, Pumps, Pond Pumps, Koi Pond Pumps, Two-Speed Pumps, Fish Pond Filters, Bio-Filters, Artificial Rocks
<?php print COMPANYNAME; ?> e-Mail Us View Cart - Check Out <?php print COMPANYNAME; ?>
'; print ''; //Determine if there are any featured products $sql = "Select c.CategoryKey as topCategory, p.CategoryKey, " . "m.CategoryKey as ManufacturerKey, m.CategoryName as ManufacturerName, " . "p.CategoryName as ProductName, s.ProductName as Size, " . "s.Price, s.OSCId, s.ProductKey " . "from Categories c join Categories m on c.CategoryKey = m.SubcategoryKey " . "Join Categories p On m.CategoryKey = p.SubCategoryKey " . "Join ProductList pl on p.CategoryKey = pl.CategoryKey " . "Join Products s on pl.ProductKey = s.ProductKey Where s.Featured = 1 and c.CategoryKey = " . $_GET['categoryKey'] . " ORDER BY s.ProductName"; $rs = mysql_query($sql); checkSQL($sql); if(mysql_num_rows($rs) != 0) { $oscURL = $ini['baseURL'] . '?merchantid=' . $ini['merchantID'] . '&productID='; print ''; print ''; print ''; print ''; print ''; print ''; } ?>


'; $pictureName = $picDir . "categories/C$categoryKey.jpg"; print '
'; if(file_exists($pictureName)) { print '' . $_GET['categoryName'] . ''; } if(empty($description)) { print 'No text entered for ' . $categoryName; } else { print $description;; } print '
'; print '

Featured ' . $_GET['categoryName'] . '

'; print '
'; print ''; print ''; print ''; print ''; print ''; print ''; print ''; while($row = mysql_fetch_assoc($rs)) { $featuredURL = "SUBcategory.php?categoryKey=" . $row['topCategory']; $featuredURL .= "&subCategoryKey=" . $row['ManufacturerKey']; $featuredURL .= "&subCategoryName=" . $row['ManufacturerName']; $featuredURL .= "&productKey=" . $row['CategoryKey']; print ''; print ''; print ''; print ''; print ''; print ''; } print ''; print '