[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 = ‘9’ “)
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 ‘
‘;
echo ‘
‘;
echo ‘
‘;
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 ‘‘;
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 ‘‘;
echo ‘
‘;
echo ‘‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘Plant Rating‘;
echo ‘‘;
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 ‘
| Garden Rating | ‘; echo $row[‘garden_rating’]; echo ‘ |
| Nectar Rating | ‘; echo $row[‘nectar_rating’]; echo ‘ |
| Caterpillar Rating | ‘; echo $row[‘cat_rating’]; echo ‘ |
‘;
echo ‘
‘;
echo ‘
‘;
echo $row[‘reviews’];
[/insert_php]