| %s |
| %s |
| %s
|
",
$myrow["nr_ad_page"],
$myrow["nr_ad_use_ID"],
$myrow["nr_ad_name"],
substr($myrow["nr_ad_textshort"],0,175),
$myrow["nr_ad_page"],
$myrow["nr_ad_use_ID"],
$myrow["nr_ads_sponsor"]
);
}
elseif($myrow["nr_ads_spnum"]==2)
{
printf("",
$myrow["nr_ad_page"],
$myrow["nr_ad_name"],
substr($myrow["nr_ad_textshort"],0,75),
$myrow["nr_ad_page"],
$myrow["nr_ads_sponsor"]
);
}
}//end while
}//end if numrows
}//end function
/////display groups
function displayGroupHeader($group,$use_ID)
{
$query = "SELECT *
FROM herbs_uses_groups
WHERE HU_groupsID = '$group'";
if(!($result = mysql_query($query)))
showerror();
//display results
while ($myrow = mysql_fetch_array($result))
{
printf("
|
", $myrow["groups_name"]);
echo" |
![\"%s\"](\"images/groups/thb/%s\")
%s
|
",
$myrow["HUG_image"],
$myrow["groups_name"],
$myrow["HUG_desc"]);
}
}////end groups
function groupTitle($group)
{
$query = "Select * from
herbs_uses_groups
where HU_groupsID = '$group'";
if(!($result = mysql_query($query)))
showerror();
//display results
while ($row = mysql_fetch_array($result))
{
$title =$row["HU_title"];
$description = substr($row["HUG_desc"],0,125);
$keywords ="Herbs Botanicals natural health, essential oils, home remedy, herbs, medicinal plants";
}//end while
echo
"". $title ."\n".
"\n".
"\n";
}//end header function
//group title
/////////////////////display uses parafunctions
function displayRelOils($use_ID)
{
$query = "SELECT oil_ID, oil_name
FROM herbs, herbs_uses,
rel_UH
WHERE oil_ID = rel_UH_oil_ID
AND use_ID = rel_UH_useID
and use_ID = '$use_ID' ";
$query.=" and aromatic is not null ";
$query.=" group BY oil_ID";
$query.=" ORDER BY oil_name";
//test result set exists
if(!($result = mysql_query($query)))
showerror();
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows != 0) {
//display results
echo "";
while ($row = mysql_fetch_array($result))
{
echo " ".
$row["oil_name"]. " *\n";
}//end while
}//end if results
echo "
";
}//end rel use function
function displayTips($use_ID){
/*display and referances related formuals rel_formulas */
$query ="SELECT * ";
$query.="from quick_tips ";
$query.= "where quick_useID = '$use_ID' ";
$query.= " LIMIT 0,10 ";
if(!($result = mysql_query($query)))
showerror();
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows != 0) {
echo "";
//display results
while ($row = mysql_fetch_array($result))
{
echo "![](\"images/star-tip.gif\")
".$row["quick_tip"]."
";
}//end while
echo "
";
}//end if rows
}//end function
function displayUsesLinks($group,$use_ID){
$query = "SELECT *
FROM herbs_uses
WHERE use_group = '$group' ";
$query.=" and use_chart = 1 ORDER BY use_name ";
if(!($result = mysql_query($query)))
showerror();
//display results
while ($myrow = mysql_fetch_array($result))
{
if ($myrow["use_ID"] != $use_ID)
{
printf("%s * ",
trim($myrow["use_ID"]),
$myrow["use_name"]);
}else
{
printf("%s * ", $myrow["use_name"]);
}
}
}
//end uses links
function checkRemLink($use_ID){
$query = "SELECT rem_use_ID, use_name, use_group
FROM remedies, herbs_uses
WHERE rem_use_ID = herbs_uses.use_ID
and rem_use_ID = '$use_ID'
GROUP BY rem_use_ID ";
//echo $query;
if(!($result = mysql_query($query)))
showerror();
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows != 0)
{
while ($myrow = mysql_fetch_array($result))
{
printf("
![\"remedy\"](\"/images/morter-pestle.jpg\")
Herbal Remedies for %s",
//trim($myrow["use_group"]),
trim($myrow["rem_use_ID"]),
$myrow["use_name"]);
}//end while
}//end if
}//end check link
function displayUsesHeader($use_ID)
{
$query = "SELECT use_ID,use_chart_title, use_symptoms, use_desc
FROM herbs_uses WHERE use_chart =1";
$query.=" and use_ID = '$use_ID' ";
if(!($result = mysql_query($query)))
showerror();
while ($row = mysql_fetch_array($result))
{
$title = $row["use_chart_title"];
$description= strip_tags(substr($row["use_desc"],0,65));
$keywords = $row["use_symptoms"];
}
echo
"". $title ."\n".
"\n".
"\n";
}//end function
function displayUsesParagraph($use_ID,$gc){
$query = "Select * from
herbs_uses
where use_ID = '$use_ID'
";
if(!($result = mysql_query($query)))
showerror();
//display results
?>
\n";
echo "| " ;
displayUsesLinks($myrow["use_group"],$use_ID);
echo " |
";
echo "| ". //for group pic
" | ";
printf("
|
| %s | |
\n
| %s |
\n
| %s |
",
$myrow["use_chart_title"],
$myrow["use_img"],
$myrow["use_name"],
$myrow["use_desc"],
$myrow["use_symptoms"]);
echo "".
"| ";
displayTips($myrow["use_ID"]);
echo" |
\n";
echo " ".
"| ";
checkRemLink ($myrow["use_ID"]);
echo " |
\n".
"
| ";
//native remedy trial ex 8/15
//displayAdsBestSellerH($oil_ID,$myrow["use_ID"]);
include("google_rec.inc");
//GoogleAds($myrow["use_group"]);
//exclusive 7-27
echo " |
\n";
echo " \n
| ";
displayRelHerbs($use_ID);
echo " |
\n";
echo " \n
| ";
displayHerbs($myrow["use_ID"]);
echo " |
\n";
echo " \n
| ";
displayRef($use_ID);
echo " |
\n";
}//end while
?>
";
while ($myrow = mysql_fetch_array($result))
{
printf("| %s | \n",
trim($myrow["page_ID"]),
$myrow["oil_name"]);
displayRefTxtNew($myrow["oil_ID"],$myrow["use_ID"]);
}
echo "";
}//end if numrows
}
//end uses function
function displayRef($use_ID)
{
$query ="SELECT books.book_ID, books.Title,books.Author ";
$query.="from books, rel_referances, rel_UH ";
$query.="where rel_ref_ID = ref_ID ";
$query.=" and books.book_ID = rel_referances.book_ID ";
$query.=" and rel_UH_useID = '$use_ID'";
$query.=" group by books.book_ID";
//echo $query;
if(!($result = mysql_query($query)))
showerror();
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
if ($numrows != 0) {
//display results
//start a row
echo "";
}//end if results
}//end ref
/////////////////////end page functions
?>