A one stop page to find out how much has been reviewed at Jerky Ingredients to date. For a detailed list of jerky bags reviewed, visit the Jerky Tags/Categories page.
[php]
$username = apply_filters( ‘username’, ” );
$password= apply_filters( ‘pwd’, ” );
$database= apply_filters( ‘databasename’, ” );
$server = apply_filters( ‘servername’, ” );
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die(“Unable to select database”);
$i=0;
$query = “select count(*) as reviewcount from bag where reviewed = ‘Y'”;
$result=mysql_query($query);
$reviewcount=mysql_result($result,$i,”reviewcount”);
$query = “select count(*) as stephanecount from bagtag where tagid = 632″;
$result=mysql_query($query);
$stephanecount=mysql_result($result,$i,”stephanecount”);
$query = “select count(*) as ingredientcount from ingredient”;
$result=mysql_query($query);
$ingredientcount=mysql_result($result,$i,”ingredientcount”);
$query = “select count(*) – 1 as typecount from jerkytype”;
$result=mysql_query($query);
$typecount=mysql_result($result,$i,”typecount”);
$query = “select count(*) as flavourcount from flavour”;
$result=mysql_query($query);
$flavourcount=mysql_result($result,$i,”flavourcount”);
$query = “select count(distinct (category)) as flavorcategorycount from flavour”;
$result=mysql_query($query);
$flavorcategorycount=mysql_result($result,$i,”flavorcategorycount”);
$query = “select count(*) as tagcount from jerkytag where tagurl is not null”;
$result=mysql_query($query);
$tagcount=mysql_result($result,$i,”tagcount”);
$query = “select count(*) as categorycount from jerkycategory”;
$result=mysql_query($query);
$categorycount=mysql_result($result,$i,”categorycount”);
$query = “select sum(cost) as totalcost from bag”;
$result=mysql_query($query);
$totalcost=mysql_result($result,$i,”totalcost”);
$query = “select format(sum(grams),0) as totalgrams
, format(sum(ounces),0) as totalounces
, round(sum(ounces) / 16,1) as totalpounds
, round(sum(ounces) / 35.274,1) as totalkilograms
from bag”;
$result=mysql_query($query);
$totalgrams=mysql_result($result,$i,”totalgrams”);
$totalounces=mysql_result($result,$i,”totalounces”);
$totalpounds=mysql_result($result,$i,”totalpounds”);
$totalkilograms=mysql_result($result,$i,”totalkilograms”);
/* Purchase Details */
$query = “select count(*) as bagcount from bag where news = ‘N'”;
$result=mysql_query($query);
$bagcount=mysql_result($result,$i,”bagcount”);
$query = “select count(*) as bagcountonline from bag where purchasestore = ‘online'”;
$result=mysql_query($query);
$bagcountonline =mysql_result($result,$i,”bagcountonline”);
$query = “select count(*) as submittedcount from bag where submitted = ‘Y'”;
$result=mysql_query($query);
$submittedcount =mysql_result($result,$i,”submittedcount”);
$query= “select count(distinct(purchasecity)) as purchasecanadacitycount from bag where purchasecountry = ‘Canada’ and purchasestate <> ‘none'”;
$result=mysql_query($query);
$purchasecanadacitycount =mysql_result($result,$i,”purchasecanadacitycount”);
$query= “select count(distinct(purchasecity)) as purchaseusacitycount from bag where purchasecountry = ‘USA’ and purchasestate <> ‘none'”;
$result=mysql_query($query);
$purchaseusacitycount=mysql_result($result,$i,”purchaseusacitycount”);
$query= “select count(distinct(purchasestate)) as purchaseprovincecount from bag where purchasecountry = ‘Canada’ and purchasestate <> ‘None'”;
$result=mysql_query($query);
$purchaseprovincecount=mysql_result($result,$i,”purchaseprovincecount”);
$query= “select count(distinct(purchasestate)) as purchasestatecount from bag where purchasecountry = ‘USA’ and purchasestate <> ‘None'”;
$result=mysql_query($query);
$purchasestatecount =mysql_result($result,$i,”purchasestatecount”);
/* Brand Details */
$query= “select count(*) as brandcount from brand”;
$result=mysql_query($query);
$brandcount=mysql_result($result,$i,”brandcount”);
$query= “select count(*) as brandusacount from brand where country = ‘USA'”;
$result=mysql_query($query);
$brandusacount=mysql_result($result,$i,”brandusacount”);
$query= “select count(*) as brandcanadacount from brand where country = ‘Canada'”;
$result=mysql_query($query);
$brandcanadacount=mysql_result($result,$i,”brandcanadacount”);
$query= “select count(*) as brandsubmittedcount from brand where submitted = ‘Y'”;
$result=mysql_query($query);
$brandsubmittedcount =mysql_result($result,$i,”brandsubmittedcount”);
$query= “select count(distinct(state)) as brandprovincecount from brand where country = ‘Canada’ and state <> ‘None'”;
$result=mysql_query($query);
$brandprovincecount=mysql_result($result,$i,”brandprovincecount”);
$query= “select count(distinct(state)) as brandstatecount from brand where country in (‘USA’,’Australia’) and state <> ‘None'”;
$result=mysql_query($query);
$brandstatecount=mysql_result($result,$i,”brandstatecount”);
/* Distributer Details */
$query= “select count(*) as distributercount from distributer”;
$result=mysql_query($query);
$distributercount=mysql_result($result,$i,”distributercount”);
$query= “select count(*) as distributerusacount from distributer where country = ‘USA'”;
$result=mysql_query($query);
$distributerusacount=mysql_result($result,$i,”distributerusacount”);
$query= “select count(*) as distributercanadacount from distributer where country = ‘Canada'”;
$result=mysql_query($query);
$distributercanadacount=mysql_result($result,$i,”distributercanadacount”);
$query= “select count(distinct(state)) as distributerprovincecount from distributer where country = ‘Canada’ and state <> ‘None'”;
$result=mysql_query($query);
$distributerprovincecount=mysql_result($result,$i,”distributerprovincecount”);
$query= “select count(distinct(state)) as distributerstatecount from distributer where country in (‘USA’,’Australia’) and state <> ‘None'”;
$result=mysql_query($query);
$distributerstatecount=mysql_result($result,$i,”distributerstatecount”);
/* Private Labeler Details */
$query= “select count(*) as privatelabelercount from privatelabel
where privatelabelid not in (-1,0)”;
$result=mysql_query($query);
$privatelabelercount =mysql_result($result,$i,”privatelabelercount”);
$query= “select count(distinct(state)) as privatelabelerprovincecount from privatelabel where country = ‘Canada’ and state <> ‘None'”;
$result=mysql_query($query);
$privatelabelerprovincecount=mysql_result($result,$i,”privatelabelerprovincecount”);
$query= “select count(distinct(state)) as privatelabelerstatecount from privatelabel where country = ‘USA’ and state <> ‘None'”;
$result=mysql_query($query);
$privatelabelerstatecount=mysql_result($result,$i,”privatelabelerstatecount”);
$query= “select count(*) as jerkyshrinemakercount from jerkyshrinemaker;”;
$result=mysql_query($query);
$jerkyshrinemakercount =mysql_result($result,$i,”jerkyshrinemakercount”);
$query= “select count(*) as jerkyshrinemakerdisplaycount from jerkyshrinemaker where jerkyshrinemakerdisplay = ‘Y’;”;
$result=mysql_query($query);
$jerkyshrinemakerdisplaycount=mysql_result($result,$i,”jerkyshrinemakerdisplaycount”);
$query= “select sum(jerkyshrinemakerbag) as jerkyshrinemakerbagcount from jerkyshrinemaker;”;
$result=mysql_query($query);
$jerkyshrinemakerbagcount =mysql_result($result,$i,”jerkyshrinemakerbagcount”);
mysql_close();
[/php]
JERKY SHRINE DETAILS
Jerky Shrine Bag Counter
Jerky Shrine Bags: [php] echo $jerkyshrinemakerbagcount; [/php]
Jerky Shrine Brand Counter
Jerky Shrine Brands: [php] echo $jerkyshrinemakercount ; [/php]
Jerky Shrine Brand On Display Counter
Jerky Shrine Brands On Display: [php] echo $jerkyshrinemakerdisplaycount; [/php]
JERKY REVIEWED DETAILS
Jerky Review Counter
Jerky Reviews: [php] echo $reviewcount; [/php]
Jerky Brands reviewed: [php] echo $brandcount; [/php]
Stéphane Leclerc Taste Reviews: [php] echo $stephanecount; [/php]
Total Weight of Jerky
[php] echo $totalgrams; [/php] Grams [php] echo $totalounces; [/php] Ounces [php] echo $totalpounds; [/php] Pounds [php] echo $totalkilograms; [/php] Kilograms
Jerky Bag Counter
Unique Jerky Bags acquired: [php] echo $bagcount; [/php]
Cost of Jerky Bags
Jerky Bags cost: $[php] echo $totalcost; [/php]
Submitted Jerky Bags Counter
Unique Submitted Jerky Bags reviewed: [php] echo $submittedcount; [/php]
Jerky Ingredient Counter
Jerky Ingredients reviewed: [php] echo $ingredientcount; [/php]
Jerky Type Counter
Jerky Types reviewed: [php] echo $typecount; [/php]
Jerky Flavor Name Counter
Jerky Flavor Names reviewed: [php] echo $flavourcount; [/php]
Jerky Flavor Tag Counter
Jerky Flavor Tags created: [php] echo $flavorcategorycount; [/php]
Jerky Tag Counter
Jerky Tags created: [php] echo $tagcount; [/php]
Jerky Category Counter
Jerky Categories created: [php] echo $categorycount; [/php]
JERKY BRAND DETAILS
Jerky Brand Counter
Jerky Brands reviewed: [php] echo $brandcount; [/php]
Jerky Brand Submitted Counter
Jerky Brands Submitted for review: [php] echo $brandsubmittedcount; [/php]
Jerky Brand Province Counter
Jerky Brand Provinces reviewed: [php] echo $brandprovincecount; [/php]
Jerky Brand State Counter
Jerky Brand States reviewed: [php] echo $brandstatecount; [/php]
Jerky Brand Country Counter
Jerky Brand Countries reviewed: 8
USA Jerky Brand Counter
United States of America Jerky Brands reviewed: [php] echo $brandusacount; [/php]
Canada Jerky Brand Counter
Canadian Jerky Brands reviewed: [php] echo $brandcanadacount; [/php]
JERKY DISTRIBUTOR DETAILS
Jerky Distributor Counter
Jerky Distributors reviewed: [php] echo $distributercount; [/php]
Jerky Distributor Province Counter
Jerky Distributor Provinces reviewed: [php] echo $distributerprovincecount; [/php]
Jerky Distributor State Counter
Jerky Distributor States reviewed: [php] echo $distributerstatecount; [/php]
Jerky Distributor Country Counter
Jerky Distributor Countries reviewed: 8
USA Jerky Distributor Counter
United States of America Jerky Distributors reviewed: [php] echo $distributerusacount; [/php]
Canada Jerky Distributor Counter
Canadian Jerky Distributors reviewed: [php] echo $distributercanadacount; [/php]
JERKY PRIVATE LABELER DETAILS
Jerky Private Labeler Counter
Jerky Private Labelers reviewed: [php] echo $privatelabelercount; [/php]
Jerky Private Labeler Province Counter
Jerky Private Labeler Provinces reviewed: [php] echo $privatelabelerprovincecount; [/php]
Jerky Private Labeler State Counter
Jerky Private Labeler States reviewed: [php] echo $privatelabelerstatecount; [/php]
Jerky Private Labeler Country Counter
Jerky Private Labeler Countries reviewed: 2
JERKY PURCHASE DETAILS
Submitted Jerky Bags Counter
Unique Submitted Jerky Bags reviewed: [php] echo $submittedcount; [/php]
Purchase Jerky Online Counter
Jerky Bags Purchased Online reviewed: [php] echo $bagcountonline; [/php]
Jerky Purchase Canada City Counter
Jerky Purchase Canada Cities reviewed: [php] echo $purchasecanadacitycount; [/php]
Jerky Purchase USA City Counter
Jerky Purchase USA Cities reviewed: [php] echo $purchaseusacitycount; [/php]
Jerky Purchase Province Counter
Jerky Purchase Provinces reviewed: [php] echo $purchaseprovincecount; [/php]
Jerky Purchase State Counter
Jerky Purchase States reviewed: [php] echo $purchasestatecount; [/php]
Jerky Purchase Country Counter
Jerky Purchase Countries reviewed: 2