"; // Editable Screen Message //---------------------------------------- print ""; //-- School //---------------------------------------- // Use ALT Database to get User List from District Directory App // Do this before db_connect include //-------------------------------------------------------------- $server = $_SERVER['SERVER_NAME']; if ($server == "www.wrsd.net") { mysql_close($con); $DBName = "mysql_wrsd"; $con = mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database"); @mysql_select_db("$DBName", $con) or die("Unable to select database $DBName"); } print "'; mysql_free_result( $result ); print ""; print "

"; print "Curriculum Home "; print "

"; $message_id=1; if ($UserType == "Admin") {$image_src = $b_admin;} else {$image_src = $b_edit;} if ($UserType == "Admin"||$UserType=="Editor") {print " ";} include "include/message.inc.php"; print "

Select your School: "; print ""; $sqlquery = "SELECT distinct school FROM district_directory order by school ASC"; $result = mysql_query($sqlquery); $number = mysql_numrows($result); $i = 0; if ($number < 1) { print "There Were No Schools returned in Your Search"; //print "$sqlquery"; } else { while ($number > $i) { // Name //------------------------- $school = mysql_result($result,$i,"school"); if ($school >=0) { print "$school"; } $i++; } } print " "; print '

"; //-- Close SQL Connection //---------------------------------------- mysql_close($con); include "include/footer.inc.php"; ?>