P – R Jerky Ingredients

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]

A – Z JERKY INGREDIENTS
A – C Jerky Ingredients ([php] echo $ingredientcountabc; [/php])	D – F Jerky Ingredients ([php] echo $ingredientcountdef; [/php])
G – I Jerky Ingredients ([php] echo $ingredientcountghi; [/php])	J – L Jerky Ingredients ([php] echo $ingredientcountjkl; [/php])
M – O Jerky Ingredients ([php] echo $ingredientcountmno; [/php])	P – R Jerky Ingredients ([php] echo $ingredientcountpqr; [/php])
S – V Jerky Ingredients ([php] echo $ingredientcountstuv; [/php])	W – Z Jerky Ingredients ([php] echo $ingredientcountwxyz; [/php])

Jerky Ingredients reviewed: [php] echo $ingredientcount; [/php]

P – R Jerky Ingredients reviewed: [php] echo $ingredientcountpqr; [/php]

[php]
$username = apply_filters( ‘username’, ” );
$password= apply_filters( ‘pwd’, ” );
$database= apply_filters( ‘databasename’, ” );
$server = apply_filters( ‘servername’, ” );

// Connect to the server and select a database
$dbh = mysqli_connect($server,$username,$password,$database) or
die(“Problem connecting: “.mysqli_error());

// Prepare statement
$sql =
‘SELECT ingredientname,description,rating,href
FROM ingredient
WHERE 1=1
and ((ingredientname like \’p%\’)
or (ingredientname like \’q%\’)
or (ingredientname like \’r%\’))
order by ingredientname’;

// Allocates and initializes a statement object suitable for mysqli_stmt_prepare().
$stmt = mysqli_stmt_init($dbh);

// Prepare statement, bind result variables, execute and place results into bound result variables
if (mysqli_stmt_prepare($stmt, $sql)) {
mysqli_stmt_bind_result($stmt,$ingredientname, $description,$rating,$href);
mysqli_stmt_execute($stmt);
// Loop through all the matching database row
while (mysqli_stmt_fetch($stmt)) {

[/php]

[php]

} // end of while statement
} // end of if statement

mysqli_close($dbh);

[/php]

P – R JERKY INGREDIENTS
Name: [php] echo $ingredientname; [/php]
Description: [php] echo $description; [/php]
Rating: [php] echo $rating; [/php]/10