"; print ""; print "
"; left_menu(); print ""; print " "; print ""; $pack_name = fetch_me("package","pack_name","pack_id",$_GET['pack_id']); // SUB-TABLE FOR PACKAGES IMAGE AND HEADING print ""; print " "; //package image $PictureListArray=Array(1=>'child_health', 'women_health', 'p_icon_liver', 'old_age_health', 'p_icon_diabetic'); $picId = (int)($_GET['pack_id']); print ""; print ""; print ""; print " "; print ""; print ""; print " "; print ""; print ""; //package heading print " "; print ""; print ""; print ""; print "
"; print "
"; print "".stripslashes($pack_name)."
 AHG ".stripslashes($pack_name)." package
"; //display text related to package if any $pack_text = stripslashes(fetch_me("package","pack_text","pack_id",$_GET['pack_id'])); if ($pack_text!="") { print ""; print ""; print ""; print ""; print "
".nl2br($pack_text)."
"; } print "
"; //SUB-TABLE FOR PACKAGE DATA print " "; print " "; //SPECIES print " "; //MEDICINAL USE print " "; //PARTS USED print ""; print " "; //PACKAGE DATA $q = "SELECT * FROM pack_plant WHERE pack_id='".$_GET['pack_id']."' "; $r = mysql_query($q) or die(mysql_error()); while($o = mysql_fetch_object($r)) { $genus = fetch_me("botmast","genus","plant_id",$o->plant_id); $species = fetch_me("botmast","species","plant_id",$o->plant_id); $qLang="SELECT * FROM ver_names WHERE plant_id =".$o->plant_id; $res = mysql_query($qLang) or die(mysql_error()); print ""; //SPECIES print " "; //VERNACULAR USE print " "; //PARTS USED print ""; print " "; } print "
SpeciesVernacular NamesParts used
$genus $species"; $OtherNames=""; while($oLang=mysql_fetch_object($res)) { if($oLang->NAME!='XXX') { $OtherNames.= $oLang->NAME. "(".$oLang->Lang_tag."), "; } } print substr($OtherNames,0,-2); print "$o->plant_part
"; print "
"; //display feature artilce if present // $art_file = fetch_me("package","art_file","pack_id",$_GET['pack_id']); // $filename = "../articles/".$art_file; $resultArtFile=mysql_query("SELECT * FROM article WHERE Pack_id='".$_GET['pack_id']."'"); if(mysql_num_rows($resultArtFile)!=0) { print ""; $FirstTime=true; while($rsArticle=mysql_fetch_object($resultArtFile)) { print ""; if($FirstTime) { if(mysql_num_rows($resultArtFile)==1) $Features="Feature"; else $Features="Features"; print ""; } else print ""; $FirstTime=false; print ""; } print "
$Features:   Art_id."\" class='boldlink'>".$rsArticle->Feature."  Art_id."\" class='boldlink'>".$rsArticle->Feature."
"; } //print ""; print ""; print ""; print ""; //display copyrights display_copyrights(); ?>