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 = 9 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 = 9 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); ?>
|
|||||||
Comic Book ReviewsA comic book or comicbook is a magazine or book containing sequential art in the form of a narrative. Comic books are often called comics for short. Although the term implies otherwise, the subject matter in comic books is not necessarily humorous, and in fact its dramatic seriousness varies widely. DC >>One of the largest comic book publishers, DC is responsible for such famous characters such as Superman, Batman, Wonder Woman,Green Lantern, The Flash, Aquaman and the teammates in the Justice League. Marvel >>The second of the two largest comic book publishers, Marvel is responsible for such characters like Spiderman, The Incredible Hulk, Daredevil, Captain American, The Fantastic Four and most famously, X-Men. Other >>This section will contain comic book publishers that are smaller than the above companies, yet still are important. Publishers include:
Dark Horse comics |
|
||||||
|