>

  IMPORTANT NOTICE ': $where .= $delim."year>='".$_GET['year']."'"; break; default: case '=': $where .= $delim."year='".$_GET['year']."'"; break; } $delim=" and "; } if ($_GET['quarter']) { $where .= $delim."quarter='".$_GET['quarter']."'"; $delim=" and "; } switch ( $_GET['view'] ) { default: case 'all': $query="select * from catalog"; if ($where) { $query .= " where (".$where.")"; } $query.= " order by code asc"; break; } $result=mysql_query($query); //if ( @mysql_num_rows($result) ) { for ( $i=0; $i<@mysql_num_rows($result); $i++ ) { $row[$i]=mysql_fetch_array($result); } $numrows=@mysql_num_rows($result); echo "

\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; if ( $numrows ) { for ( $i=0; $i<$numrows; $i++ ) { $color=rowcolor($i); $local_row=$row[$i]; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; if ( $_GET['show_descriptions'] == 'on' || FALSE ) { echo "\n"; } } } else { $color=rowcolor(0); echo "\n"; } echo "

"; echo "

\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo "

Degree

\n"; // degree $query="select distinct degree from catalog order by degree asc"; $result=mysql_query($query); echo "\n"; echo "

Title

\n"; // title $query="select distinct title from catalog order by title asc"; $result=mysql_query($query); echo "\n"; echo "

Instructor

\n"; // instructor $query="select distinct instructor from catalog order by instructor asc"; $result=mysql_query($query); echo "\n"; echo "

Year

\n"; echo "\n"; // year $query="select distinct year from catalog order by year asc"; $result=mysql_query($query); echo "\n"; echo "

Quarter

\n"; // quarter echo "\n"; echo "

Show Descriptions?

\n"; // show descriptions? echo "\n"; echo "

 

\n"; echo "\n"; // echo "
\n"; echo "\n"; echo "

Degree

Class

Instructor

Offered

".strtoupper($local_row['degree'])."

"; echo $local_row['title']." (".strtoupper($local_row['code']).") "; echo "

".$local_row['instructor']."

"; switch ( $local_row['quarter'] ) { case 'f': echo "Fall"; break; case 'w': echo "Winter"; break; case 's': echo "Spring"; break; case 'm': echo "Summer"; break; } echo " ".$local_row['year']; echo "

".$local_row['description']."

No Results

\n"; echo "
\n"; echo "

\n"; //} else { // //echo "

No results\n"; //echo "

$query\n"; // //} ?>

*** NOTICE ***
This code is preliminary and may do unexpected things. The tool is experimental and may not work and/or break at various times, doing various things. The data is incomplete and from preliminary versions of the catalogs and may be innacurate or not reflect what actually is offered. The tool is not permanent and may go away or not be available without future notice. Etc ... Etc ...
*** NOTICE ***