$x_cat=$_GET['cat'];
$cat= $x_cat;
if ( ! $cat ) { ?>
Welcome to the EduWebs Curriculum
Resources Page. Please click use the navigation bar to the left in order to
display information from our database.
} else {
$db="eduprof" ; $user="ewprof" ; $pass="blwt95" ;
if ( !$mysql_link=mysql_connect("localhost",$user,$pass))
print "database connect failure";
if ( !mysql_select_db($db,$mysql_link)) {
print "database select failure";
break;
}
$query="SELECT * FROM curric WHERE CAT LIKE '%".$cat."%'";
if( !$mysql_result=mysql_query($query,$mysql_link))
print "Error on database query: $query";
if( !mysql_numrows( $mysql_result )>= 1 )
print "No matching records in database.";
?>
Internet
Resources for echo $cat; ?> |
while( $row=mysql_fetch_row($mysql_result)){
$area=$row[1]; $title= $row[2]; $link=$row[3]; $info=$row[4];
print "";
print "$area | $title | ";
print " ";
if ($info) {
print "";
print " | ";
print "$info | ";
print " ";
}
}
print " ";
}
?>
|