Jerky Counters

JerkyIngredients.comA 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”);

mysql_close();
[/php]

JERKY 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 brands from Canada   Jerky Brand Provinces reviewed: [php] echo $brandprovincecount; [/php]

Jerky Brand State Counter

USA Flag  Australian Flag  Ecuador Flag  Russia Flag  Jerky Brand States reviewed: [php] echo $brandstatecount; [/php]

Jerky Brand Country Counter

Jerky Brand Countries reviewed: 8
Canada Flag  USA Flag  Taiwan Flag  Australian Flag  Lithuania Flag  England Flag  Ecuador Flag  Russia Flag

USA Jerky Brand Counter

United States of America Jerky Brands reviewed: A jerky brand name from the USA  [php] echo $brandusacount; [/php]

Canada Jerky Brand Counter

Canadian Jerky Brands reviewed: A jerky brand name from Canada  [php] echo $brandcanadacount; [/php]

JERKY DISTRIBUTOR DETAILS

Jerky Distributor Counter

Jerky Distributors reviewed: [php] echo $distributercount; [/php]

Jerky Distributor Province Counter

Jerky distributors from Canada  Jerky Distributor Provinces reviewed: [php] echo $distributerprovincecount; [/php]

Jerky Distributor State Counter

Jerky distributors from the USA  Australian Flag  Ecuador Flag  Russia Flag  Jerky Distributor States reviewed:   [php] echo $distributerstatecount; [/php]

Jerky Distributor Country Counter

Jerky Distributor Countries reviewed: 8
Canada Flag  USA Flag  Taiwan Flag  Australian Flag  Lithuania Flag  England Flag  Ecuador Flag  Russia Flag

USA Jerky Distributor Counter

United States of America Jerky Distributors reviewed: A jerky distributor name from the USA  [php] echo $distributerusacount; [/php]

Canada Jerky Distributor Counter

Canadian Jerky Distributors reviewed: A jerky distributor name from Canada  [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 labelers from Canada   Jerky Private Labeler Provinces reviewed: [php] echo $privatelabelerprovincecount; [/php]

Jerky Private Labeler State Counter

Jerky private labelers from the USA   Jerky Private Labeler States reviewed: [php] echo $privatelabelerstatecount; [/php]

Jerky Private Labeler Country Counter

Canada Flag  USA Flag  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 bags purchased from Canada   Jerky Purchase Canada Cities reviewed: [php] echo $purchasecanadacitycount; [/php]

Jerky Purchase USA City Counter

Jerky brands from the USA   Jerky Purchase USA Cities reviewed: [php] echo $purchaseusacitycount; [/php]

Jerky Purchase Province Counter

Jerky bags purchased from Canada   Jerky Purchase Provinces reviewed: [php] echo $purchaseprovincecount; [/php]

Jerky Purchase State Counter

Jerky brands from the USA   Jerky Purchase States reviewed: [php] echo $purchasestatecount; [/php]

Jerky Purchase Country Counter

Canada Flag  USA Flag  Jerky Purchase Countries reviewed: 2