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 "); ?>
|
|||||||
Science Fiction Book ReviewsWelcome to theScience Fiction section of the Outpost Library. Since this is one of the most popular literary genre's for our members, we have divided it into 3 new areas of interest. Click on the Section you are interested in to find our reviewer's favorite authors and their bestselling work. Reviews are in alphabetical order by author - click on the Authors name by the book title to read the review. However, note that where we have large Series of books, they may be in numerical order, or alphabetized by title. Earth >>The Earth section features books that take place on our home plaet Earth. Wether past, present or future, events, people, places and things may be familiar to you, but with a twist provided by these talented authors. Space >>Space favorites chosen by our reviewing staff because they are located in our known galaxy. Inspired by television or movies, classic collections, or just darn good ideas and execution, these books are unique in their look to the future and how we will get "out there" and what we will find. Alternate Universes >>For the alternate universe fan, this is the place to really stretch your imagination. Dr. Who is a real presence here, as are the entire Vorkosigian series by Bujold. And a heck of alot of other good stuff. These stories will make you think and travel outside what we think we know to places we can only hope to find one day. |
|
||||||
|