The Daily Dirt Blog  Subscribe to The Daily Dirt    
Garden Tutorials Pocket Garden Guides Gardening FAQs Tree Care Library Plant Encyclopedia


"; } else { $image=""; } } else { $image="
No Pic
"; } if (!$cult) { $cult="n/a"; } echo "
$image

$sci
( $comm )

$desc
Important Info : $info

Click To Expand Menus

Characteristics
Cultivar:$cult  
Family:$fam  
Size:Height: $hmin ft. to $hmax ft.
Width: $wmin ft. to $wmax ft.  
Plant Category:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='PLANT_CATEGORY' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from PlantCategory where PLANT_CATEGORY_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Plant Characteristics:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='PLANT_CHAR' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from PlantChar where PLANT_CHAR_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Foliage Characteristics:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='FOLIAGE_CHAR' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from FoliageChar where FOLIAGE_CHAR_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Foliage Color:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='FOLIAGE_COLOR' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from FoliageColor where FOLIAGE_COLOR_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Flower Characteristics:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='FLOWER_CHAR' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from FlowerChar where FLOWER_CHAR_ID ='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Flower Color:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='FLOWER_COLOR' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from FlowerColor where FLOWER_COLOR_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; echo "$cat, "; } echo " 
Tolerances:"; $query="select TABLE_SID from PlantXref where PLANT_SID='$id' AND TABLE_NAME='PLANT_TOLERANCE' "; $result=mysql_query($query)or die ('Xref Query failed because ' . mysql_error()); while( $row=mysql_fetch_row($result)) { $tid=$row[0]; $query2="select SHORT_DESC from PlantTolerance where PLANT_TOLERANCE_ID='$tid' "; $result2=mysql_query($query2)or die ('Xref Query failed because ' . mysql_error()); $row2=mysql_fetch_row($result2); $cat=$row2[0]; if (is_null($cat)) { $cat="n/a"; } echo "$cat, "; } echo " 
Requirements
Bloomtime Range:$brange  
USDA Hardiness Zone:$hrrange  
AHS Heat Zone:$htzone  
Light Range:$lrange  
pH Range:$phrange  
Soil Range:$srange  
Water Range:$wrange  
"; echo "
Plant Care

Fertilizing
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Fertilizing' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Light
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Light' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Watering
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Watering' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Planting
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Planting' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Problems
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Problems' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Miscellaneous
"; $query3="select t1.INSTRUCTION_DESC,t1.INSTRUCTION_NAME,t2.INSTRUCTION_TYPE,t2.INSTRUCTION_SUBTYPE FROM Instruction as t1 LEFT JOIN InstructionType as t2 ON t1.INSTRUCTION_TYPE_ID=t2.INSTRUCTION_TYPE_ID LEFT JOIN InstructionXref as t3 ON t1.INSTRUCTION_SID=t3.INSTRUCTION_SID WHERE t3.PLANT_SID='$id' AND t2.INSTRUCTION_TYPE='Miscellaneous' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $name=$row3[1]; $itype=$row3[2]; $sub=$row3[3]; echo "$sub : $name

$desc

"; } echo"
Plant Images
"; $query3="select t1.PICTURE_DESC,t1.PICTURE_HEIGHT,t1.PICTURE_FILE,t1.PICTURE_WIDTH FROM Picture as t1 WHERE t1.PLANT_SID='$id' AND t1.PICTURE_SIZE_TYPE_ID='F' "; $result3=mysql_query($query3); while ($row3=mysql_fetch_row($result3)) { $desc=$row3[0]; $height=$row3[1]; $pic1=$row3[2]; $width=$row3[3]; $pic="http://onlinegardener.com/large/$pic1"; echo " "; } echo "
$desc \"\"


"; mysql_free_result($result); mysql_free_result($result3); mysql_close($dbh); } //end if id ?>