Library Databases
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";
}
}
?>