All jerky ingredients reviewed done with an ingredient starting with the letter P, Q or R.
[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 ingredientcount from ingredient”;
$result=mysql_query($query);
$ingredientcount=mysql_result($result,$i,”ingredientcount”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountabc from ingredient
where substr(ingredientname,1,1) in (‘A’,’B’,’C’)”;
$result=mysql_query($query);
$ingredientcountabc=mysql_result($result,$i,”ingredientcountabc”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountdef from ingredient
where substr(ingredientname,1,1) in (‘D’,’E’,’F’)”;
$result=mysql_query($query);
$ingredientcountdef=mysql_result($result,$i,”ingredientcountdef”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountghi from ingredient
where substr(ingredientname,1,1) in (‘G’,’H’,’I’)”;
$result=mysql_query($query);
$ingredientcountghi=mysql_result($result,$i,”ingredientcountghi”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountjkl from ingredient
where substr(ingredientname,1,1) in (‘J’,’K’,’L’)”;
$result=mysql_query($query);
$ingredientcountjkl=mysql_result($result,$i,”ingredientcountjkl”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountmno from ingredient
where substr(ingredientname,1,1) in (‘M’,’N’,’O’)”;
$result=mysql_query($query);
$ingredientcountmno=mysql_result($result,$i,”ingredientcountmno”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountpqr from ingredient
where substr(ingredientname,1,1) in (‘P’,’Q’,’R’)”;
$result=mysql_query($query);
$ingredientcountpqr=mysql_result($result,$i,”ingredientcountpqr”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountstuv from ingredient
where substr(ingredientname,1,1) in (‘S’,’T’,’U’,’V’)”;
$result=mysql_query($query);
$ingredientcountstuv=mysql_result($result,$i,”ingredientcountstuv”);
$query = “select count(substr(ingredientname,1,1)) as ingredientcountwxyz from ingredient
where substr(ingredientname,1,1) in (‘W’,’X’,’Y’,’Z’)”;
$result=mysql_query($query);
$ingredientcountwxyz=mysql_result($result,$i,”ingredientcountwxyz”);
mysql_close();
[/php]
Jerky Ingredients reviewed: [php] echo $ingredientcount; [/php]
P – R Jerky Ingredients reviewed: [php] echo $ingredientcountpqr; [/php]