"; if ( $check == "All" ) $box .= "\nAll"; else $box .= "\nAll"; while($val = mysql_fetch_row($result)){ if ( $val[0] == $check ) $box .= "\n$val[0]"; else $box .= "\n$val[0]"; } $box .=""; } else $box = ""; return $box; } // createComboBox #------------------------------------------------------------------------------- echo "\nStart time: ".date("H:i:s"); echo "
Main page"; $con = mysql_pconnect("fiber.forestry.uga.edu","work","work"); $colA = getVar("a"); $colB = getVar("b"); $colC = getVar("c"); $colD = getVar("d"); $header = "

".createComboBox("a",$con,$colA)."

".createComboBox("b",$con,$colB)."

".createComboBox("c",$con,$colC)."

".createComboBox("d",$con,$colD)."

"; $table = ""; $sql = "select * from tempDatabase.tableTest"; if ( $colA!= "NULL" && $colB!= "NULL" && $colC != "NULL" && $colD != "NULL"){ if ( !($colA == "All" && $colB == "All" && $colC == "All" && $colD == "All") ){ $sql .= " where "; $sqlArray = array(); if ( $colA != "All" ) array_push($sqlArray, "a = '$colA'"); if ( $colB != "All" ) array_push($sqlArray, "b = '$colB'"); if ( $colC != "All" ) array_push($sqlArray, "c = '$colC'"); if ( $colD != "All" ) array_push($sqlArray, "d = '$colD'"); $sql .= implode(" and ",$sqlArray); } #echo "
".$sql.""; $result = mysql_query($sql,$con); $colour1 = "#efefef"; $colour2 = "#afafaf"; $colour = $colour2; while($r = mysql_fetch_row($result)){ if ( $colour == $colour2 ) $colour = $colour1; else $colour = $colour2; $table .= "\n"; $i = 0; while ( $i < 30) { $table .=""; $i++; } $table .= ""; } $table .= "

$r[$i]

"; } echo "$header$table"; echo "\nFinish time: ".date("H:i:s"); ?>