prepare("select * from Plants where web_url like '" . ($_REQUEST['name']) . "'"); $sqlPlantResult->execute(); $sqlPlantRowNum = $sqlPlantResult->rowCount(); $sPlantRow = $sqlPlantResult->fetch(PDO::FETCH_ASSOC); # Get image number $iImageNum = $sPlantRow['plantnumber']; $iImageNum = str_replace(".", "-", $iImageNum); # Check if image exists if ( file_exists("/home/do180/www/perennials.com/perennials/" . $iImageNum . ".jpg") ) : # Watermark src example: /watermark.php?path=perennials/1-550-480.jpg&watermark=images/watermark_heritage.png # Add watermark $sImageToShow = "/watermark.php?path=perennials/" . $iImageNum . ".jpg&watermark=images/watermark_heritage.png&xpos=.88&ypos=.95"; //if ($sPlantRow['plant_type'] == "1" || $sPlantRow['plant_type'] == "17" || $sPlantRow['plant_type'] == "33" || $sPlantRow['plant_type'] == "73" || $sPlantRow['plant_type'] == "65" || $sPlantRow['plant_type'] == "9" || $sPlantRow['plant_type'] == "129") : $sImageToShow = "/watermark.php?path=perennials/" . $iImageNum . ".jpg&watermark=images/watermark_heritage.png&xpos=.88&ypos=.95"; //elseif ($sPlantRow['plant_type'] == "3" || $sPlantRow['plant_type'] == "7" || $sPlantRow['plant_type'] == "67") : $sImageToShow = "/watermark.php?path=perennials/" . $iImageNum . ".jpg&watermark=images/watermark_jeepers.png&xpos=.99&ypos=1.0"; //elseif ($sPlantRow['plant_type'] == "5" || $sPlantRow['plant_type'] == "69" || $sPlantRow['plant_type'] == "133") : $sImageToShow = "/watermark.php?path=perennials/" . $iImageNum . ".jpg&watermark=images/watermark_rockstars.png&xpos=.99&ypos=1.0"; //else : $sImageToShow = "/perennials/" . $iImageNum . ".jpg"; endif; else : $sImageToShow = "/images/space.gif"; endif; if ($sqlPlantRowNum == 0) : die(header ("Location: /notfound.html")); endif; ?> Plant Profile for <? echo $sPlantRow['italicname']; ?> - <? echo $sPlantRow['common_name'] . " Perennial"; ?>
"") : echo "
Photo courtesy of " . $sPlantRow['image1_photocredit_id'] . "

"; endif; ?>


USDA Zone: -

Plant number:


"; elseif ($sPlantRow['planttype'] == "rockstars") : echo ""; elseif ($sPlantRow['planttype'] == "hea") : echo ""; elseif ($sPlantRow['planttype'] == "heritage") : echo ""; endif; ?>
Disclaimer: This information is presented for reference only. This plant is not currently part of our Heritage Perennials lineup."; endif; ?>



No related results found.
"; else : echo "
More results related to '" . $sParentName . "'
"; echo "
"; $sqlRelatedPlantTotalResult = $pdoConnection->prepare("select plantnumber from Plants where italicname like '" . ($sParentName) . "%';"); $sqlRelatedPlantTotalResult->execute(); $sqlRelatedPlantTotalRowNum = $sqlRelatedPlantTotalResult->rowCount(); $sqlRelatedPlantResult = $pdoConnection->prepare("select plantnumber, italicname, common_name, web_url from Plants where italicname like '" . ($sParentName) . "%' order by rand() limit 14;"); $sqlRelatedPlantResult->execute(); $sqlRelatedPlantRowNum = $sqlRelatedPlantResult->rowCount(); echo '
'; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; echo '
'; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; $sRelatedPlantRow = ($sqlRelatedPlantResult->fetch(PDO::FETCH_ASSOC)); if (isset($sRelatedPlantRow['italicname']) && ($sRelatedPlantRow['italicname'] <> "")) : echo "" . funcFitString($sRelatedPlantRow['italicname'], 57) . "
"; endif; echo '
'; endif; echo "
"; if ($sqlRelatedPlantTotalRowNum > 0) : echo "
All " . $sqlRelatedPlantTotalRowNum . " results hereAlphabetical list of all 4,000+ perennials here

"; endif; ?>



*/ ?>



USDA Zone: -

Plant number:


"; elseif ($sPlantRow['planttype'] == "rockstars") : echo ""; elseif ($sPlantRow['planttype'] == "hea") : echo ""; elseif ($sPlantRow['planttype'] == "heritage") : echo ""; endif; ?>
Disclaimer: This information is presented for reference only. This plant is not currently part of our Heritage Perennials lineup."; endif; ?>