The Value Of User Submitted Data
Herbal Elements Community Database is a database of entries by users like you based on first hand experience with certain species for medicinal or other purposes. As we accumulate data, we will be able to see trends in the effectiveness of certain herbs as well as read detailed first hand experiences.

All Dabatase Entries Categorized By Purpose/Use
Click on categories to see individual entries

"; } $i=0; while ($i < $num) { $herbtype=mysql_result($result,$i,"herbtype"); $herbuse=mysql_result($result,$i,"herbuse"); echo ""; echo "", ucwords($herbuse)," | "; echo "$herbtype | "; //@mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM herbreviews WHERE herbuse = '$herbuse' AND herbtype = '$herbtype'"; $result2=mysql_query($query); $num2=mysql_numrows($result2); if ($num2 == 1){echo $num2, " entry";} else{echo $num2, " entries";}; echo""; $i++; } mysql_close(); ?>