and the rest, since it wouldn't let me submit it all
if ($myrow["SCeng"] > 0) { printf("Support Center English (%s), ",$myrow["SCeng"]); }
if ($myrow["SCmath"] > 0) { printf("Support Center Math (%s), ",$myrow["SCmath"]); }
if ($myrow["SCsci"] > 0) { printf("Support Center Science (%s), ",$myrow["SCsci"]); }
if ($myrow["SChealth"] > 0) { printf("Support Center Health (%s), ",$myrow["SChealth"]); }
if ($myrow["SChist"] > 0) { printf("Support Center U.S. History (%s), ",$myrow["SChist"]); }
if ($myrow["SCsurvey"] > 0) { printf("Support Center Soc. Sci. Survey (%s), ",$myrow["SCsurvey"]); }
if ($myrow["E120"] > 0) { printf("E120 English (%s), ",$myrow["E120"]); }
if ($myrow["E220"] > 0) { printf("E220 English (%s), ",$myrow["E220"]); }
if ($myrow["E320"] > 0) { printf("E320 English (%s), ",$myrow["E320"]); }
if ($myrow["E420"] > 0) { printf("E420 English (%s), ",$myrow["E320"]); }
if ($myrow["M170"] > 0) { printf("M170 Essential Math (%s), ",$myrow["M170"]); }
if ($myrow["M270"] > 0) { printf("M270 Algebra and Geometry Concepts (%s), ",$myrow["M270"]); }
if ($myrow["M370"] > 0) { printf("M370 Consumer Math (%s), ",$myrow["M370"]); }
if ($myrow["E190"] > 0) { printf("E190 Reading (%s), ",$myrow["E190"]); }
if ($myrow["E290"] > 0) { printf("E290 Reading (%s), ",$myrow["E290"]); }
if ($myrow["E390"] > 0) { printf("E390 Reading (%s), ",$myrow["E390"]); }
if ($myrow["E490"] > 0) { printf("E490 Reading (%s), ",$myrow["E490"]); }
if ($myrow["S170"] > 0) { printf("S170 Science (%s), ",$myrow["S170"]); }
if ($myrow["S270"] > 0) { printf("S270 Science (%s), ",$myrow["S270"]); }
if ($myrow["G370"] > 0) { printf("G370 History (%s), ",$myrow["G370"]); }
if ($myrow["G470"] > 0) { printf("G470 Survey (%s), ",$myrow["G470"]); }
if ($myrow["R152"] > 0) { printf("R152 Life Strat (%s), ",$myrow["R152"]); }
if ($myrow["R153"] > 0) { printf("R153 Learning Strat (%s), ",$myrow["R153"]); }
if ($myrow["R252"] > 0) { printf("R252 Life Strat (%s), ",$myrow["R252"]); }
if ($myrow["R253"] > 0) { printf("R253 Learning Strat (%s), ",$myrow["R253"]); }
if ($myrow["R355"] > 0) { printf("R355 PSAE Strat (%s), ",$myrow["R355"]); }
if ($myrow["Z12650"] > 0) { printf("Z126 LRP Resource - 50 min/week (%s), ",$myrow["Z12650"]); }
if ($myrow["Z126125"] > 0) { printf("Z126 LRP Resource - 125 min/week (%s), ",$myrow["Z126125"]); }
if ($myrow["Z126250"] > 0) { printf("Z126 LRP Resource - 250 min/week (%s), ",$myrow["Z126250"]); }
if ($myrow["Z12750"] > 0) { printf("Z127 GS Resource - 50 min/week (%s), ",$myrow["Z12750"]); }
if ($myrow["Z127125"] > 0) { printf("Z127 GS Resource - 125 min/week (%s), ",$myrow["Z127125"]); }
if ($myrow["Z127250"] > 0) { printf("Z127 GS Resource - 250 min/week (%s), ",$myrow["Z127250"]); }
if ($myrow["center"] > 0) { printf("Resource Service Center (%s), ",$myrow["center"]); }
if ($myrow["25week"] > 0) { printf("Counseling/Social Work - 25 min/week (%s), ",$myrow["25week"]); }
if ($myrow["50month"] > 0) { printf("Counseling/Social Work - 50 min/month (%s), ",$myrow["50month"]); }
if ($myrow["50qtr"] > 0) { printf("Counseling/Social Work - 25 min/quarter (%s), ",$myrow["50qtr"]); }
if ($myrow["boys"] > 0) { printf("Boys Group (%s), ",$myrow["boys"]); }
if ($myrow["girls"] > 0) { printf("Girls Group (%s), ",$myrow["girls"]); }
if ($myrow["speech"] > 0) { printf("Speech/Lang Services (%s), ",$myrow["speech"]); }
if ($myrow["adaptive"] > 0) { printf("P112 Adaptive PE (%s), ",$myrow["adaptive"]); }
if ($myrow["drivers"] > 0) { printf("P210/220 Spec. Driver's Ed (%s), ",$myrow["drivers"]); }
if ($myrow["life"] > 0) { printf("H171 Intro to Life and Family (%s), ",$myrow["life"]); }
if ($myrow["tech"] > 0) { printf("T130 Applied Tech (%s), ",$myrow["tech"]); }
if ($myrow["key"] > 0) { printf("B101 Intro to Keyboarding (%s), ",$myrow["key"]); }
if ($myrow["key2"] > 0) { printf("B201 Intro to Keyboarding II (%s), ",$myrow["key2"]); }
if ($myrow["ors"] > 0) { printf("ORS Services (%s), ",$myrow["ors"]); }
if ($myrow["cap"] > 0) { printf("College Awareness Program (%s), ",$myrow["cap"]); }
if ($myrow["trans"] > 0) { printf("Transition Screening (%s), ",$myrow["trans"]); }
if ($myrow["comments"]) { printf("<br><b>Comments</b>: %s ",$myrow["comments"]); }
if ($entries == 0) { printf("There are no recommendations entered for this student"); }
}
}
}
}
/
if ($last) {
$result = mysql_query("SELECT FROM recs",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
if ($myrow["last"] == $last) {
printf("Here it is!");
}
}
while ($myrow = mysql_fetch_array($result));
}
else {
printf ("Sorry, no recommendations for %s were found!", $last);
}
}
*/
mysql_close();
$submit = 0;
printf("<br><br><a href=results.php>Go back</a>\n");
} else{
// display form
?>
<b>RECOMMENDATION RESULTS PAGE</b>
<br><br>
Select a student from the drop down list to see the student's recommendation summary. In the summary, the number inside the parentheses denotes the number of times a particular class/service was recommended.
<BR><BR>
<form action="results.php" method="post">
Select Student:
<select name="index">
<?php
$username="xxx";
$password="xxx";
$database="xxx";
$db = mysql_connect("localhost",$username,$password) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query("SELECT * FROM students",$db);
// display list if there are records to display
while ($myrow = mysql_fetch_array($result)) {
printf(" <option value=\"%s\">%s, %s\n",$myrow["index"],$myrow["last"],$myrow["first"]);
}
mysql_close();
?>
</select>
<br>
<br>
<input type="Submit" name="submit" value="Show Recommendation Summary">
</form>
----- or -----
<br><br>
<b><a href="allresults.php">Show All Results</a></b>
<br><br>
<b><a href="index.htm">Back to Main Page</a></b>
<?php
} // end if
?>
</body>
</html>
