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 = 5 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 = 5 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=11 ORDER BY series ASC "); ?>
|
|||||||||||
Science Fiction "Space" BooksOne of our favorite sections of the Library is Space, where all these books take place. The Space we refer to is the "known space" of our own galaxy. These books are not planet bound, unless you have no imagination, and don't believe we ever got to the moon. For the non-believers, better go read something else. But if you want a real ride to the stars, pick out one of these classics by Robert A. Heinlein, Timothy Zahn, Ben Bova or Poul Anderson. These authors are some of the best of the best authors of the Sci-Fi genre' and you won't be disappointed with any of our selections. Unless you pick a book rated 1 - then you are on your own. As in all the Science Fiction sub-sections, just click on the Authors name by the book you are interested in. Take a trip to the stars and have fun! while ($myrow = mysql_fetch_row($series)) { echo("$myrow[0]"); echo("
|
|
||||||||||
|