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