require ("../includes/header.ssi");
?>
Library Databases
include ("dbconnect.php");
switch($_GET['mode']) {
case "1":
$sub = "select subject from subject where id = '$_GET[id]'";
$subresult = mysql_query($sub) or die (mysql_error());
list ($subject)= mysql_fetch_row($subresult);
$sql = "select db.id as did,name,url,description from db,subject,subject_lookup where subject.id = '$_GET[id]' and subject_lookup.sid='$_GET[id]' and subject_lookup.dbid=db.id order by name";
$result = mysql_query($sql) or die (mysql_error());
echo "Library Databases > By Subject > $subject";
while (list($did,$name,$url,$description) = mysql_fetch_row($result))
{
echo "\n- $name
\n- $description
\n
\n";
}
break;
case "2":
$sql = "select db.id as did,name,url,description from db where name like '$_GET[let]%' order by name";
$result = mysql_query($sql) or die (mysql_error());
echo "Library Databases > By Title > $_GET[let]";
while (list($did,$name,$url,$description) = mysql_fetch_row($result))
{
echo "\n- $name
\n- $description
\n
\n";
}
break;
case "3":
$searchstring = mysqli_escape_string($keywords);
$sql = "select distinct name,url,description from db where match (name,description) against ('$searchstring') order by name";
$result = mysql_query($sql) or die (mysql_error());
echo "Library Databases > By Keyword";
while (list($name,$url,$description) = mysql_fetch_row($result))
{
echo "\n- $name
\n- $description
\n
\n";
}
break;
default:
$how = "Library Databases > By Subject";
$sql = "select db.id as did,name,url,description from db,subject,subject_lookup where subject.id = '$id' and subject_lookup.sid=$id and subject_lookup.dbid=db.id order by name";
$result = mysql_query($sql) or die (mysql_error());
echo "$how
\n";
while (list($did,$name,$url,$description) = mysql_fetch_row($result))
{
echo "\n- $name
\n- $description.
\n
\n";
}
}
?>