SEARCH BY SPECIES
(leave default values to see all entries)


plant fungi animal other

SEARCH BY USE/PURPOSE
(leave default values to see all entries)

plant fungi animal other



"; echo "
All Unique Uses Matching Your Search Criteria


"; if ($num==0) { echo "There are no entries pertaining to your search words, please confirm spelling or try another field
"; } $i=0; while ($i < $num) { $herbtype=mysql_result($result,$i,"herbtype"); $herbuse=mysql_result($result,$i,"herbuse"); echo ""; echo " $herbuse | "; echo "$herbtype | "; //@mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM herbreviews WHERE herbuse LIKE '%{$herbuse}%' AND herbtype LIKE '%{$herbtype}%'"; $result2=mysql_query($query); $num2=mysql_numrows($result2); echo " $num2 entries"; echo""; $i++; } mysql_close(); ?>