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 = 4 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 = 4 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=8 ORDER BY series ASC "); ?>
|
|||||||||||
Supernatural Book List: Supernatural Books reviewed by Outpost 10F membersThe Supernatural section is a collection of books that deal with horror, the unexplained, the powers of the mind, and things that "go bump in the night". As you can see, Stephen King and Anne Rice are two of our readers favorite authors, as well they should be. But there are many other choices for the reader who wants to be kept awake long after everyone else is asleep. Nightmares are optional once you get into these stories, and we do suggest a night light if you are easily scared by your own imagination. There are so many of these books on the shelf at the bookstore, and we hope that all our members who appreciate a good "goosebumps" book will volunteer to add to this collection. We welcome every one to contribute to the success of the Library and offer more choices for our members. while ($myrow = mysql_fetch_row($series)) { echo("$myrow[0]"); echo("
|
|
||||||||||
|