problem connecting to database...\n"; } // end if $select = mysql_select_db($dbName); if (!$select){ print mysql_error() . "
\n"; } // end if return $dbConn; } // end connectToDatabase function testView(){ global $dbConn,$tableName; $query = "SELECT * FROM $tableName ORDER BY event"; $output = ""; $result = mysql_query($query, $dbConn); /*$output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; */ $x=0; while ($row=mysql_fetch_row($result)) { if($row[17] == "y") { if($row[1]=="sr_trebuchet_performance" || $row[1]=="sr_trebuchet_technical_paper" || $row[1]=="sr_treb_display" || $row[1]=="sr_treb_oral_presentation" || $row[1]=="jr_trebuchet_performance" || $row[1]=="jr_trebuchet_technical_paper" || $row[1]=="jr_trebuchet_display" || $row[1]=="jr_trebuchet_oral_presentation") { $output .= "
Event NamePlaceWinner 1Winner 2Winner 3Winner 4School NameComments
\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="jr_teammath_cat_1" || $row[1]=="jr_teammath_cat_2" || $row[1]=="sr_teammath_cat_a" || $row[1]=="sr_teammath_cat_b" || $row[1]=="sr_teammath_cat_c" || $row[1]=="sr_speak_out" ) { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="sr_speak_easy" || $row[1]=="sr_solomath_lev_1" || $row[1]=="sr_solomath_lev_2" || $row[1]=="sr_solomath_lev_3" || $row[1]=="sr_solomath_lev_4" || $row[1]=="sr_solomath_lev_5" || $row[1]=="jr_speakup" || $row[1]=="jr_solomath_general_math" || $row[1]=="jr_solomath_prealgebra" || $row[1]=="jr_solo_algebra" || $row[1]=="jr_solo_geometry") { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if } //end if } //end while //$output .= "\n"; return $output; } // end testview function getname($competition) { if($competition=="jr_trebuchet_performance"){$name="Junior Trebuchet - Performance";} else if($competition=="jr_trebuchet_technical_paper"){$name="Junior Trebuchet – Technical Paper";} else if($competition=="jr_trebuchet_display"){$name="Junior Trebuchet – Acad. Display";} else if($competition=="jr_trebuchet_oral_presentation"){$name="Junior Trebuchet – Oral Pres.";} else if($competition=="jr_mousetrap"){$name="Junior Mousetrap Cars";} else if($competition=="jr_sticktogether"){$name="Junior Stick Together";} else if($competition=="jr_manilla_mechanics"){$name="Junior Manila Mechanics";} else if($competition=="jr_web_design"){$name="Junior Website Design";} else if($competition=="jr_eggxpress"){$name="Junior EggXpress";} else if($competition=="jr_model_science"){$name="Junior Model Science";} else if($competition=="jr_crystals"){$name="Junior Crystals";} else if($competition=="jr_soil_science"){$name="Junior Soil Science";} else if($competition=="jr_speakup"){$name="Junior Speak Up";} else if($competition=="jr_teammath_cat_1"){$name="Junior Team Math Quest – Category I";} else if($competition=="jr_teammath_cat_2"){$name="Junior Team Math Quest – Category II";} else if($competition=="jr_solomath_general_math"){$name="Junior Solo Math – Gen Math";} else if($competition=="jr_solomath_prealgebra"){$name="Junior Solo Math – Pre-Algebra";} else if($competition=="jr_solo_algebra"){$name="Junior Solo Math – Algebra ";} else if($competition=="jr_solo_geometry"){$name="Junior Solo Math – Geometry";} else if($competition=="sr_trebuchet_performance"){$name="Senior Trebuchet - Performance";} else if($competition=="sr_trebuchet_technical_paper"){$name="Senior Trebuchet – Technical Paper";} else if($competition=="sr_treb_display"){$name="Senior Trebuchet – Acad. Display";} else if($competition=="sr_treb_oral_presentation"){$name="Senior Trebuchet – Oral Pres.";} else if($competition=="sr_mousetrap"){$name="Senior Mousetrap Cars";} else if($competition=="sr_civil_structs"){$name="Senior Civil Structures";} else if($competition=="sr_manilla_mechanics"){$name="Senior Manila Mechanics";} else if($competition=="sr_web_design"){$name="Senior Website Design";} else if($competition=="sr_eggxpress"){$name="Senior EggXpress";} else if($competition=="sr_model_science"){$name="Senior Model Science";} else if($competition=="sr_wright_stuff"){$name="Senior Wright Stuff";} else if($competition=="sr_speak_out"){$name="Senior Speak Out";} else if($competition=="sr_speak_easy"){$name="Senior Speak Easy";} else if($competition=="sr_teammath_cat_a"){$name="Senior Team Math Quest – Category A";} else if($competition=="sr_teammath_cat_b"){$name="Senior Team Math Quest – Category B";} else if($competition=="sr_teammath_cat_c"){$name="Senior Team Math Quest – Category C";} else if($competition=="sr_solomath_lev_1"){$name="Senior Solo Math – Level 1";} else if($competition=="sr_solomath_lev_2"){$name="Senior Solo Math – Level 2";} else if($competition=="sr_solomath_lev_3"){$name="Senior Solo Math – Level 3";} else if($competition=="sr_solomath_lev_4"){$name="Senior Solo Math – Level 4";} else if($competition=="sr_solomath_lev_5"){$name="Senior Solo Math – Level 5";} return $name; } function doesntexist($competition) { global $dbConn; $query="SELECT * FROM competition WHERE event='$competition'"; $result= mysql_query($query, $dbConn); $row = mysql_fetch_row($result); if($row<1) {return true;} else{return false;} } function add($event,$winner1,$winner2,$winner3,$winner4,$school,$comments) { global $dbConn, $tableName; $query = "UPDATE $tableName SET inuse='y' WHERE event='$event'"; //$query = "INSERT into $tableName VALUES(NULL,'$event',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'y')"; $result = mysql_query($query, $dbConn); /*if ($result){ print "

Record Successfully Added

\n"; } else { print mysql_error(); print "

There was an error

\n"; }*/ } function update($event,$winner1,$winner2,$winner3,$winner4,$winner5,$winner6,$winner7,$winner8,$winner9,$winner10,$winner11,$winner12,$school1,$school2,$school3,$submitted,$comments) { global $dbConn, $tableName; $query = "UPDATE $tableName SET winner1='$winner1', winner2='$winner2', winner3='$winner3', winner4='$winner4', winner5='$winner5', winner6='$winner6', winner7='$winner7', winner8='$winner8',winner9='$winner9', winner10='$winner10', winner11='$winner11', winner12='$winner12',school1='$school1',school2='$school2',school3='$school3',submitted='$submitted', comments='$comments' WHERE event='$event'"; $result = mysql_query($query, $dbConn); if ($result){ print "

The scores were submitted successfully!

\n"; } else { print mysql_error(); print "

There was an error, please contact an official immediately...

\n"; } } function showslackers(){ global $dbConn,$tableName; $query = "SELECT * FROM $tableName WHERE submitted='n'"; $output = ""; $result = mysql_query($query, $dbConn); $output="The Following Events Have NOT Yet Submitted Their Results

"; while ($row=mysql_fetch_row($result)) { $output.="".getname($row[1])."
"; } $output.= "



Competition Winners



"; //end while //$output .= "\n"; return $output; } // end qToTable function initialize() { global $dbConn, $tableName; //$query = array(); $query[0] = "INSERT into $tableName VALUES(NULL,'jr_trebuchet_performance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[1] = "INSERT into $tableName VALUES(NULL,'jr_trebuchet_technical_paper',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[2] = "INSERT into $tableName VALUES(NULL,'jr_trebuchet_display',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[3] = "INSERT into $tableName VALUES(NULL,'jr_trebuchet_oral_presentation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[4] = "INSERT into $tableName VALUES(NULL,'jr_mousetrap',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[5] = "INSERT into $tableName VALUES(NULL,'jr_sticktogether',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[6] = "INSERT into $tableName VALUES(NULL,'jr_manilla_mechanics',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[7] = "INSERT into $tableName VALUES(NULL,'jr_web_design',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[8] = "INSERT into $tableName VALUES(NULL,'jr_eggxpress',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[9] = "INSERT into $tableName VALUES(NULL,'jr_model_science',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[10] = "INSERT into $tableName VALUES(NULL,'jr_crystals',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[11] = "INSERT into $tableName VALUES(NULL,'jr_soil_science',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[12] = "INSERT into $tableName VALUES(NULL,'jr_speakup',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[13] = "INSERT into $tableName VALUES(NULL,'jr_teammath_cat_1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[14] = "INSERT into $tableName VALUES(NULL,'jr_teammath_cat_2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[15] = "INSERT into $tableName VALUES(NULL,'jr_solomath_general_math',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[16] = "INSERT into $tableName VALUES(NULL,'jr_solomath_prealgebra',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[17] = "INSERT into $tableName VALUES(NULL,'jr_solo_algebra',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[18] = "INSERT into $tableName VALUES(NULL,'jr_solo_geometry',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[19] = "INSERT into $tableName VALUES(NULL,'sr_trebuchet_performance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[20] = "INSERT into $tableName VALUES(NULL,'sr_trebuchet_technical_paper',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[21] = "INSERT into $tableName VALUES(NULL,'sr_treb_display',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[22] = "INSERT into $tableName VALUES(NULL,'sr_treb_oral_presentation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[23] = "INSERT into $tableName VALUES(NULL,'sr_mousetrap',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[24] = "INSERT into $tableName VALUES(NULL,'sr_civil_structs',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[25] = "INSERT into $tableName VALUES(NULL,'sr_manilla_mechanics',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[26] = "INSERT into $tableName VALUES(NULL,'sr_web_design',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[27] = "INSERT into $tableName VALUES(NULL,'sr_eggxpress',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[28] = "INSERT into $tableName VALUES(NULL,'sr_model_science',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[29] = "INSERT into $tableName VALUES(NULL,'sr_wright_stuff',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[30] = "INSERT into $tableName VALUES(NULL,'sr_speak_out',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[31] = "INSERT into $tableName VALUES(NULL,'sr_speak_easy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[32] = "INSERT into $tableName VALUES(NULL,'sr_teammath_cat_a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[33] = "INSERT into $tableName VALUES(NULL,'sr_teammath_cat_b',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[34] = "INSERT into $tableName VALUES(NULL,'sr_teammath_cat_c',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[35] = "INSERT into $tableName VALUES(NULL,'sr_solomath_lev_1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[36] = "INSERT into $tableName VALUES(NULL,'sr_solomath_lev_2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[37] = "INSERT into $tableName VALUES(NULL,'sr_solomath_lev_3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[38] = "INSERT into $tableName VALUES(NULL,'sr_solomath_lev_4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $query[39] = "INSERT into $tableName VALUES(NULL,'sr_solomath_lev_5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,'n')"; $blob = connectToDatabase(); $newtable = "DROP table competition"; $newtable2 = "CREATE TABLE competition( id int NOT NULL AUTO_INCREMENT, event varchar(200), winner1 varchar(100), winner2 varchar(100), winner3 varchar(100), winner4 varchar(100), winner5 varchar(100), winner6 varchar(100), winner7 varchar(100), winner8 varchar(100), winner9 varchar(100), winner10 varchar(100), winner11 varchar(100), winner12 varchar(100), school1 varchar(100), school2 varchar(100), school3 varchar(100), submitted varchar(1), comments blob, inuse varchar(1), PRIMARY KEY (id) )"; $result = mysql_query($newtable, $blob); if ($result) { print "

Table Dropped

\n"; } else { print mysql_error(); print "

There was an error

\n"; } $result = mysql_query($newtable2, $blob); if ($result) { print "

Table Created

\n"; } else { print mysql_error(); print "

There was an error

\n"; } for($count=0;$count<40;$count +=1) { $qnum = $query[$count]; $result = mysql_query($qnum, $blob); if ($result) { print "

Record Successfully Added

\n"; } else { print mysql_error(); print "

There was an error

\n"; } } } function testView2(){ global $dbConn,$tableName; $query = "SELECT * FROM $tableName WHERE event like \"sr%\" ORDER BY event"; $output = ""; $result = mysql_query($query, $dbConn); //print $result; //print mysql_error(); /*$output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; */ $x=0; while ($row=mysql_fetch_row($result)) { if($row[17] == "y") { if($row[1]=="sr_trebuchet_performance" || $row[1]=="sr_trebuchet_technical_paper" || $row[1]=="sr_treb_display" || $row[1]=="sr_treb_oral_presentation" || $row[1]=="jr_trebuchet_performance" || $row[1]=="jr_trebuchet_technical_paper" || $row[1]=="jr_trebuchet_display" || $row[1]=="jr_trebuchet_oral_presentation") { $output .= "
Event NamePlaceWinner 1Winner 2Winner 3Winner 4School NameComments
\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="jr_teammath_cat_1" || $row[1]=="jr_teammath_cat_2" || $row[1]=="sr_teammath_cat_a" || $row[1]=="sr_teammath_cat_b" || $row[1]=="sr_teammath_cat_c" || $row[1]=="sr_speak_out" ) { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="sr_speak_easy" || $row[1]=="sr_solomath_lev_1" || $row[1]=="sr_solomath_lev_2" || $row[1]=="sr_solomath_lev_3" || $row[1]=="sr_solomath_lev_4" || $row[1]=="sr_solomath_lev_5" || $row[1]=="jr_speakup" || $row[1]=="jr_solomath_general_math" || $row[1]=="jr_solomath_prealgebra" || $row[1]=="jr_solo_algebra" || $row[1]=="jr_solo_geometry") { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if } //end if } //end while //$output .= "\n"; return $output; } // end testview function testView3(){ global $dbConn,$tableName; $query = "SELECT * FROM $tableName WHERE event like \"jr%\" ORDER BY event"; $output = ""; $result = mysql_query($query, $dbConn); //print $result; //print mysql_error(); /*$output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; */ $x=0; while ($row=mysql_fetch_row($result)) { if($row[17] == "y") { if($row[1]=="sr_trebuchet_performance" || $row[1]=="sr_trebuchet_technical_paper" || $row[1]=="sr_treb_display" || $row[1]=="sr_treb_oral_presentation" || $row[1]=="jr_trebuchet_performance" || $row[1]=="jr_trebuchet_technical_paper" || $row[1]=="jr_trebuchet_display" || $row[1]=="jr_trebuchet_oral_presentation") { $output .= "
Event NamePlaceWinner 1Winner 2Winner 3Winner 4School NameComments
\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="jr_teammath_cat_1" || $row[1]=="jr_teammath_cat_2" || $row[1]=="sr_teammath_cat_a" || $row[1]=="sr_teammath_cat_b" || $row[1]=="sr_teammath_cat_c" || $row[1]=="sr_speak_out" ) { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else if($row[1]=="sr_speak_easy" || $row[1]=="sr_solomath_lev_1" || $row[1]=="sr_solomath_lev_2" || $row[1]=="sr_solomath_lev_3" || $row[1]=="sr_solomath_lev_4" || $row[1]=="sr_solomath_lev_5" || $row[1]=="jr_speakup" || $row[1]=="jr_solomath_general_math" || $row[1]=="jr_solomath_prealgebra" || $row[1]=="jr_solo_algebra" || $row[1]=="jr_solo_geometry") { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if else { $output .= "\n"; //get column headings //get field names $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n"; //$output .= "\n"; //$output .= "\n"; $output .= "\n"; $output .= "\n"; $output .= "\n\n"; if($x==0){$color="#FFCC00";$x=1;} else{$color="green"; $x=0;} $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; $output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; //$output .= ""; //$output .= ""; $output .= ""; //$output .= "\n"; $output .= "
Event NamePlaceStudent 1Student 2Student 3Student 4Center NameOverall Comments
".getname($row[1])."1st".$row[2]."".$row[3]."".$row[4]."".$row[5]."".$row[14]."".$row[18]."
2nd".$row[6]."".$row[7]."".$row[8]."".$row[9]."".$row[15]."
3rd".$row[10]."".$row[11]."".$row[12]."".$row[13]."".$row[16]."


\n"; }//end first if } //end if } //end while //$output .= "\n"; return $output; } // end testview function excel() { //include 'library/config.php'; //include 'library/opendb.php'; global $dbConn,$tableName; $query = "SELECT * FROM competition"; $result = mysql_query($query,$dbConn) or die('Error, query failed'); $tsv = array(); $html = array(); while($row = mysql_fetch_array($result, MYSQL_NUM)) { $tsv[] = implode("\t", $row); $html[] = "" .implode("", $row) . ""; } $tsv = implode("\r\n", $tsv); $html = "" . implode("\r\n", $html) . "
"; $fileName = 'mysql-to-excel.xls'; header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$fileName"); //echo $tsv; echo $html; } ?>