mysql_connect(localhost, "otf_books", "l1brarY0f10f");
@mysql_select_db("outpost10f") or die("Unable to select database");
$recentReviews = mysql_query("
SELECT
item.title,
item.filename,
genre.folder,
subgenre.folder
FROM
library_review as review,
library_item as item,
library_subgenre as subgenre,
library_genre as genre
WHERE
item.itemID = review.itemID AND
item.genreID = 1 AND
item.subgenreID = subgenre.subgenreID AND
item.genreID = genre.genreID
ORDER BY
review.reviewDate DESC
LIMIT
4
");
$topReviewers = mysql_query("
SELECT
officer.officerID,
officer.handle,
officer.rankLevelID,
count(*) as total
FROM
Officer as officer,
library_review as review,
library_item as item
WHERE
review.reviewerID = officer.officerID AND
review.itemID = item.itemID AND
item.genreID = 1
GROUP BY
officer.officerID
ORDER BY
total DESC
LIMIT 4
");
$series = mysql_query("
SELECT
series,
seriesID
FROM
library_series
WHERE
subgenreID=37
ORDER BY
series ASC
");
?>
Star Trek Voyager (VOY) Books - Star Trek Voyager (VOY) Book List
Search
Outpost 10f Library
Enterprise (ENT) Books
while ($myrow = mysql_fetch_row($series)) {
echo("
$myrow[0]
");
echo("
\n\n");
$classic = mysql_query("
SELECT
item.title,
item.filename,
author.firstName,
author.lastName
FROM
library_item as item,
library_author as author
WHERE
item.subgenreID = 37 AND
item.authorID = author.authorID AND
item.seriesID = $myrow[1]
ORDER BY
item.title ASC
");
while ($myrow = mysql_fetch_row($classic)) {
echo("\t
OTF and the Outpost Library are supported by our good friends at Amazon.com. However, the books selected, the reviews and the comments of our writers are our own. To find books and buy books, click here to connect directly to Amazon.com