Sweet Maria's Coffee Glossary

All Terms:
(A-C), (A-C), (D-L), (D-L), (M-S), (M-S), (T-Z) (T-Z)

By Category:
   Brewing"; else print "Brewing"; ?>    Chemistry"; else print "Chemistry"; ?>    Equipment"; else print "Equipment"; ?>    Flavor"; else print "Flavor"; ?>    Roasting"; else print "Roasting"; ?>    Origin"; else print "Origin"; ?>
   Processing"; else print "Processing"; ?>    Biology/Cultivars"; else print "Biology/Cultivars"; ?>    Trade Terms"; else print "Trade Terms"; ?>    Sweet Maria's Terms"; else print "Sweet Maria's Terms"; ?>    Defects"; else print "Defects"; ?>

0 AND '".$_GET['category']."' AND term > '".$min_a."' and term < '".$max_a."' ORDER BY term ASC;"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { $t = ucwords(stripslashes($row['term'])); $s = stripslashes($row['short_description']); $f = stripslashes($row['full_description']); $cats = ""; if ($row['flavor']==1) $cats = $cats."Flavor "; if ($row['chemistry']==1) $cats = $cats."Chemistry "; if ($row['equipment']==1) $cats = $cats."Equipment "; if ($row['roast']==1) $cats = $cats."Roasting "; if ($row['origin']==1) $cats = $cats."Origins "; if ($row['process']==1) $cats = $cats."Processing "; if ($row['brew']==1) $cats = $cats."Brewing "; if ($row['cultivar']==1) $cats = $cats."Biology/Cultivars "; if ($row['trade']==1) $cats = $cats."Trade Terms "; if ($row['SM']==1) $cats = $cats."Sweet Maria's Terms "; if ($row['defect']==1) $cats = $cats."Defects "; $rq = "SELECT related FROM flavor_related WHERE term='".$row['term']."';"; $rr = mysql_query($rq) or die(mysql_error()); $rel = ""; while ($row = mysql_fetch_assoc($rr)) { $w = stripslashes($row['related']); $rel = $rel."".ucwords(trim($w))." "; } $query2 = "SELECT synonym FROM flavor_synonyms WHERE main_term='".$t."';"; $result2 = mysql_query($query2) or die(mysql_error()); while ($row2 = mysql_fetch_assoc($result2)) { print ""; } print "
$t
$f
Related Terms:
$rel
Categories:
$cats

"; } mysql_close($conn); ?>