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 = 2 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 = 2 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); ?>
|
|||||||
Star Wars Book Reviews"A long time ago in a galaxy far, far away...." started it all on 25 May, 1977. Since that time, more than 80 books, comics, anthologies and graphic novels have been written and it appears there is no end in sight. As the collection has grown, so has our Library. Since April, 2001, the outstanding efforts of our avid readers and writers, and the continued excellence of the chosen authors have directed us to separate Star Wars into 2 sections, Classic Trilogy and Expanded Universe. Before Battle of Yavin >>After the Battle of Yavin >> |
|
||||||
|