"; $row = mysql_fetch_array($sql); $recordid = $row["RECORDID"]; $thiscat1 = $row["CAT1"]; $cat2 = $row["CAT2"]; $new_row = $row["CAT2"]; $manufacturer = $row["MANUFACTURER"]; $productname = stripslashes($row["PRODUCTNAME"]); $dogdesc = stripslashes($row["DOGDESC"]); $catdesc = stripslashes($row["CATDESC"]); $dogdescbrief = stripslashes($row["DOGDESCBRIEF"]); $catdescbrief = stripslashes($row["CATDESCBRIEF"]); $whatisinit = stripslashes($row["WHATISINIT"]); $howtouse = stripslashes($row["HOWTOUSE"]); $imgthumb = $row["IMGTHUMB"]; $imglrg = $row["IMGLRG"]; $size = $row["SIZE"]; $dealer = $row["DEALER"]; $wholesale = $row["WHOLESALE"]; $retail = $row["RETAIL"]; $sale = $row["SALE"]; $cartdesc = $row["CARTDESC"]; $sku = $row["SKU"]; $wildcode = $row["WILDCODE"]; $publish = $row["PUBLISH"]; $metatitle = $row["METATITLE"]; $horsedescbrief = stripslashes($row["HORSEDESCBRIEF"]); $horsedesc = stripslashes($row["HORSEDESC"]); $weight = $row["WEIGHT"]; /// DETERMINE RETAIL PRICE TO USE if ($sale > 0) { $useprice = $sale; } else { $useprice = $retail; } $allow_purchase = "yes"; ///////////// DETERMINE WHAT PRICING LEVELS TO SHOW if($cfpordertype == "wholesale") { if($wholesale == 0) { $pricedisplay = "This product is currently not available for wholesale purchase
"; $allow_purchase = "no"; } else { $pricedisplay = "
Wholesale:$$wholesale
Dealer:$$dealer *
\n"; } } else { /////////// MUST BE RETAIL VISITOR, NOW CHECK FOR DISCOUNT PRICING if ($sale > 0) { $pricedisplay = "Sale Price: $ $useprice
Reg Price: $ $retail "; } else { $pricedisplay = "Price: $$retail"; } } //if($cat1 == "") { $cat1 = "dog"; } if ($_SESSION[WHICH_SPECIES] == "dog") { $thisdesc = $dogdesc; } else if ($_SESSION[WHICH_SPECIES] == "cat") { $thisdesc = $catdesc; } else if ($_SESSION[WHICH_SPECIES] == "horse") { $thisdesc = $horsedesc; } else { $thisdesc = $dogdesc; } if($metatitle == "") { $metatitle = "Pet Care - " . $cat2 . " - " . $productname; } $metadesc = $metatitle . " - Azmira Holistic and Natural Pet Products"; page_header(); echo " "; } echo "
$productname
$size
$pricedisplay

Description
$thisdesc

"; if ($whatisinit != "") { echo "What Is In It?
$whatisinit

"; } if ($howtouse != "") { echo "How To Use It
$howtouse

"; } if($allow_purchase == "yes") { echo "
Qty
"; page_footer(""); ?>