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 = 3 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 = 3 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=43 ORDER BY series ASC "); ?>
|
|||||||
Fantasy BooksHere you will find our fantasy book list, from Tolkien to McCaffrey, Laurell K. Hamilton and Mercedes Lackey, Ursula K. LeGuin and J.K. Rowling. If you notice that we are missing one of your favorite fantasy books, do let us know, or submit a review of your own to add to our collection of Fantasy reading. Just click on the title of the fantasy book you are intereted in, and enjoy our reviewers comments. Escape to places filled with dragons, wizards, knights and damsels in distress, heros and villians, and true calssice of this genre' - just read a fantasy book and go places you can only imagine! while ($myrow = mysql_fetch_row($series)) { echo(" $myrow[0]"); echo("
|
|
||||||
|