$results = mysql_query(“SELECT U.firstname, U.lastname, G.finalgrade, Q.course, Q.name, U.email, L.date, Q.required, G.itemid FROM mdl_user U INNER JOIN mdl_grade_grades G ON U.id=G.userid INNER JOIN mdl_quiz_names_tg Q ON G.itemid=Q.id LEFT JOIN mdl_qp_list L ON L.lastname=U. lastname AND L. firstname=U.firstname AND L.course=Q.course WHERE G.finalgrade >= 85 AND L.date IS NULL ORDER BY U.lastname, Q.course, Q.required DESC, Q.id”);

$count = 0;
echo “Dairy: 18 core modules and 7 of the 10 elective modules; Meat: 21 core modules and 9 of the 12 elective modules”;
echo “

“;

while($row = mysql_fetch_array($results, MYSQL_BOTH)) {
if ($row[finalgrade] > 85) {$check = “Yes”;} else {$check = “No”;}
if ($row[course]==2) {$course = “Dairy”;} else {$course = “Meat”;}
#if ($row[lastname] == $last && $row[course] == $cc) {++$count;} else {$count = 1;}
#if ($row[lastname] == $last && $row[required] == $rr) {} else {$count = 1;}
#if ($course == “Dairy” && $count ==18 ; {echo “

“;}
$first = $row[firstname]; $last = $row[lastname]; $cc = $row[course]; $rr = $row[required];
}

echo “

“;

?>