QP List

          


Connection error because: ‘ . mysql_error() . ‘‘);}

$flag = mysql_select_db($database);
if (!$flag) {die(‘Database error because: ‘ . mysql_error() . ‘Total Number by certification

“;

while($row = mysql_fetch_array($results, MYSQL_BOTH)) {
echo “

“;
}
$total = mysql_fetch_array(mysql_query(“SELECT COUNT(certification) FROM mdl_qp_list”),MYSQL_NUM);
echo “

“;
echo “

Certification Number
” . $row[0] . “ ” . $row[1] . “
Total ” . $total[0] . “

“;

echo”

“;

$results = mysql_query(“SELECT L.country, A.statename, COUNT(case when L.course = ‘2’ then 1 end) as DAIRY, COUNT(case when L.course = ‘4’ then 1 end) as MEAT, L.certification, L.state, L.course FROM mdl_qp_list L LEFT JOIN mdl_state_abbrev A ON L.state=A.state GROUP BY L.state ORDER BY L.country DESC, L.state, L.certification”);
echo “

Total Number by certification and state

“;

while($row = mysql_fetch_array($results, MYSQL_BOTH)) {
echo “

“;
}
$total = mysql_fetch_array(mysql_query(“SELECT COUNT(case when L.course = ‘2’ then 1 end) as DAIRY, COUNT(case when L.course = ‘4’ then 1 end) as MEAT FROM mdl_qp_list L”),MYSQL_BOTH);
echo “

“;
echo “

Country State Dairy QP Number* Meat QP Number*
” . $row[0] . “ ” . $row[1] . “ ” . $row[2] . “ ” . $row[3] . “
Total ” . $total[0] . “ ” . $total[1] . “

“;

echo “

“;
?>
*English and Spanish certification combined.

Individual QP

Sort by:

Last Name
Certification (Dairy or Meat)
Country/State


Name State/Country Certification

Associations

“;

while($row = mysql_fetch_array($results, MYSQL_ASSOC)) {
$assoc1 = str_replace(“;”, “
“, $row[“assoc”]);
echo “

” . $row[“lastname”] . “, ” . $row[“firstname”] . “ ” . $row[“state”] . “ ” . $row[“certification”] . “ ” . $assoc1 . “

“;
}
echo “

“;
/*
*/
?>