= 1) { $subject_v = $_REQUEST['subject']; $sqlquery = "SELECT subject FROM subjects WHERE (`id` = $subject_v)"; $result = mysql_query($sqlquery); //print "$sqlquery"; $number = mysql_numrows($result); $subject = mysql_result($result,0,"subject"); mysql_free_result( $result ); } else $subject_v = 0; ?>

"; //-- Grades //---------------------------------------- print ""; print "'; mysql_free_result( $result ); //-- Big Ideas //---------------------------------------- // SQL Draft & Public //---------------------- if ($loggedIn) { if ($UserType == "Admin") {$sql_where = "WHERE (`subject` = $subject_v)";} else {$sql_where = "WHERE (`subject` = $subject_v and `draft` = 'no')";} } else {$sql_where = "WHERE (`subject` = $subject_v and `draft` = 'no' and `public` = 'yes')";} $sqlquery = "SELECT * FROM ideas $sql_where order by sort ASC, idea ASC"; $result = mysql_query($sqlquery); $number = mysql_numrows($result); $i = 0; if ($number < 1) { print "There Were No Results for Your Search"; //print "$sqlquery"; } else { while ($number > $i) { // Name //------------------------- $key = mysql_result($result,$i,"id"); $idea = mysql_result($result,$i,"idea"); $draft = mysql_result($result,$i,"draft"); $public = mysql_result($result,$i,"public"); if ($i%2) {$bgc = "FFFFFF";} else {$bgc = "CADDA6";} if ($key >=0) { print ""; print ""; print ""; } $i++; } } //-- Close SQL Connection //---------------------------------------- mysql_free_result( $result ); mysql_close($con); ?> "; print "Curriculum Home "; print " Select a Grade:"; print ""; $sqlquery = "SELECT * FROM grades WHERE (`draft` = 'no' and `public` = 'yes') order by sort ASC"; $result = mysql_query($sqlquery); $number = mysql_numrows($result); $i = 0; if ($number < 1) { print "There Were No Grades returned in Your Search"; //print "$sqlquery"; } else { while ($number > $i) { // Name //------------------------- $key = mysql_result($result,$i,"id"); $grade = mysql_result($result,$i,"grade"); $draft = mysql_result($result,$i,"draft"); $public = mysql_result($result,$i,"public"); if ($key >=0) { if ($key == $UserGrade) { print "$grade";} else { print "$grade";} } $i++; } } print " and a $subject "; print ' "Big Idea" from the list below. $idea "; if ($UserType == "Admin") {$image_src = $b_admin;} else {$image_src = $b_edit;} if ($UserType == "Admin"||$UserType=="Editor") {print "";} print "  "; if ($loggedIn) { if ($draft == "yes") {print ' D';} else {print '   ';} if ($public == "no") {print ' P';} } print "