Butterfly Garden Plants

[insert_php]

// Make a MySQL Connection
mysql_connect(“localhost”, “nababutt_user”, “361user”) or die(mysql_error());
mysql_select_db(“nababutt_test”) or die(mysql_error());

// Get record from the “plants” table
$result = mysql_query(“SELECT * “.
“FROM plants “.
“WHERE plants.id = ‘7’ “)
or die(mysql_error());
$row = mysql_fetch_array($result);

echo ‘

‘;
echo $row[‘english_name’];
echo ‘

‘;
echo ‘

(‘;
echo $row[‘scientific_name’];
echo ‘
)

‘;

echo ‘

Other common names for this plant include ‘;
echo $row[‘other_names’];
echo ‘

‘;

echo ‘General Information
‘;
echo ‘Cultural Requirements
‘;
echo ‘Native Range
‘;
echo ‘Plant Rating
‘;
echo ‘Plant Reviews
‘;
echo ‘
‘;

echo ‘General Information‘;
echo ‘NABA_DividerBar‘;
echo ‘
‘;
echo ‘

Firewheel (Gaillardia pulchella)
Firewheel (Gaillardia pulchella)
‘;
echo ‘
Lyside Sulphur on Firewheel
Lyside Sulphur on Firewheel
‘;
echo $row[‘introduction’];

echo ‘

‘;

echo ‘Importance as a butterfly nectar source:‘;

echo ‘
‘;

echo $row[‘butt_nectar_source’];

echo ‘

‘;

echo ‘Importance as a caterpillar food source:‘;

echo ‘
‘;

echo $row[‘cat_food_source’];

echo ‘

 

‘;

echo ‘Cultural Requirements‘;

echo ‘NABA_DividerBar‘;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

USDA Hardiness Zone‘;
echo $row[‘usda’];
echo ‘
Bloom Period‘;
echo $row[‘bloom_period’];
echo ‘
Bloom Color‘;
echo $row[‘bloom_color’];
echo ‘
Plant Height‘;
echo $row[‘height’];
echo ‘
Plant Spread‘;
echo $row[‘spread’];
echo ‘
Light Exposure‘;
echo $row[‘light’];
echo ‘
Soil Moisture‘;
echo $row[‘moisture’];
echo ‘
Animal/Disease Problems‘;
echo $row[‘problems’];
echo ‘

‘;

echo ‘

 

‘;
echo ‘Native Range‘;
echo ‘NABA_DividerBar‘;
echo ‘
‘;

echo ‘';
echo $row['scientific_name'];
echo '‘;

echo ‘

 

‘;
echo ‘

 

‘;
echo ‘

 

‘;
echo ‘

 

‘;
echo ‘

 

‘;
echo ‘

 

‘;
echo ‘Plant Rating‘;
echo ‘NABA_DividerBar‘;
echo ‘
‘;
echo ‘Plant rating scale ranges from 0 to 3. Plants rating 3 are the most useful for butterfly gardens. For more details on the ratings, see Native Plant Ratings‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

Garden Rating‘;
echo $row[‘garden_rating’];
echo ‘
Nectar Rating‘;
echo $row[‘nectar_rating’];
echo ‘
Caterpillar Rating‘;
echo $row[‘cat_rating’];
echo ‘

‘;

echo ‘

 

‘;

echo ‘Plant Reviews
NABA_DividerBar‘;

echo ‘
‘;
echo $row[‘reviews’];

[/insert_php]