setsql("$query"); $db->selectquery(); $id = $db->result[0]['id']; $pic_name = $db->result[0]['pic_name']; $scientific = $db->result[0]['scientific']; $common = $db->result[0]['common']; $family = $db->result[0]['family']; $duration = $db->result[0]['duration']; $habit = $db->result[0]['habit']; $bloom_color = $db->result[0]['bloom_color']; $bloom_time = $db->result[0]['bloom_time']; $native_distribution = $db->result[0]['native_distribution']; $light_requirements = $db->result[0]['light_requirements']; $soil_moisture = $db->result[0]['soil_moisture']; $ilink = $db->result[0]['ilink']; ?> North Central Chapter of the Native Plant Society of Texas
       
Return to the Spring Plant Sale
   

spacer
The Plant Sale was held in conjunction with the:
NPSOT Fall Native Plant and Butterfly Event


2019 FALL NATIVE PLANT SALE


Pictures shown are from last year's 2019 Fall Sale.


.jpg" alt=" " width="500" height="375">


Scientific:
Common:
Family:
Duration:
Habit:
Bloom Color:
Bloom Time:
Distribution:
Light Requirements:
Soil Moisture:
Additional Information:
" target="_blank">The Wildflower Center
   
Click on the thumbnail pictures below to to see the large picture.

setsql($query); $db1->selectquery(); $num_items = count($db1->result); // ------------------------- $db2 = new mysqldb(); $query = "SELECT id, pic_name, common, scientific, category, ps, npsot, npsot_butterfles "; $query .= "FROM plants "; $query .= "WHERE npsot_butterfles = '1'"; $query .= "ORDER BY common ASC "; $db2->setsql($query); $db2->selectquery(); $num_items_2 = count($db2->result); // print "$num_items
"; for($j = 0; $j < 2; $j++) { if($j == 1) { print""; print""; print""; $num_items = $num_items_2; } $current_col = 0; $last_category = ""; $picture_row = ""; $text_row = ""; $full_row = ""; $npsot_butterfles = ""; for($i = 0; $i < $num_items; $i++) { if($j == 0) { $last_category = $category; $id = $db1->result[$i]['id']; $pic_name = $db1->result[$i]['pic_name']; $common = $db1->result[$i]['common']; $scientific = $db1->result[$i]['scientific']; $category = $db1->result[$i]['category']; } else { $id = $db2->result[$i]['id']; $pic_name = $db2->result[$i]['pic_name']; $common = $db2->result[$i]['common']; $scientific = $db2->result[$i]['scientific']; } $current_col++; if(($category != $last_category) AND ($j == 0)) { if($full_row != 1 && $i != 0) { while($current_col <= $num_across) { $picture_row .= "\n"; $text_row .= "\n"; $current_col++; } print"$picture_row\n$text_row"; $current_col = 1; } switch($category) { case 110: $cat_header = "P E R E N N I A L S"; break; case 115: $cat_header = "B I E N N I A L S"; break; case 120: $cat_header = "A N N U A L S"; break; case 130: $cat_header = "V I N E S"; break; case 140: $cat_header = "G R O U N D C O V E R S"; break; case 150: $cat_header = "S H R U B S"; break; case 160: $cat_header = "T R E E S"; break; case 170: $cat_header = "G R A S S E S  &  S E D G E S"; break; case 180: $cat_header = "C A C T I  &  S U C C U L E N T S"; break; case 190: $cat_header = "A Q U A T I C"; break; default: $cat_header = "U N C L A S S I F I E D"; break; } print""; print""; print""; $full_row = 0; } switch($current_col) { case 1: $picture_row = " "; $text_row = " "; $full_row = 0; break; case $num_across: $picture_row .= " "; $text_row .= " "; print"$picture_row\n$text_row"; $current_col = 0; $full_row = 1; break; default: $picture_row .= " "; $text_row .= " "; $full_row = 0; break; } } if($current_col) { while($current_col < $num_across) { $picture_row .= "\n"; $text_row .= "\n"; $current_col++; } print"$picture_row\n$text_row"; } } ?>





Butterfly recomended...

Host & Nectar Plants

These plants are also shown in their respective categories above.
 
    
$cat_header 
 
$common
$scientific

   
$common
$scientific
 
 $common
$scientific