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 = 1 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 = 1 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=2 ORDER BY series ASC "); ?>
|
|||||||||||||
Star Trek The Next Generation (TNG) BooksStar Trek - The Next Generation, the television series, was met with great dismay by many of the TOS fans. Those fans asked out loud - 'How in the world could "they" do this? Replace Kirk and Spock and Scotty and the rest of the crew with a bunch of "newbies"? Who thought they could get away with that? and be successful at it?' Well, seems the skeptics were proved wrong, as, just like the adventures of the old "Enterprise", Captain Jean Luc Picard and his exceptional crew of Starfleet officers and other assorted characters (who can ignore Q or Mrs. Troi? - Guinan and the Borg?). They have thrived and developed to the levels of the older cast, and some say even more. New ideas, mixed with some old ones from the TOS generation, created a unique ensumble of action-packed TV - the Star Trek way. With the TV series, merchendise and movie were to follow. Along with them, we've had the privilege of getting lots of Star Trek - The Next Generation books! So, take a look at what we have, go ahead, read a few, buy a couple, write a review for the Outpost Library and share your love for this very special series with us! while ($myrow = mysql_fetch_row($series)) { echo("$myrow[0]"); echo("
|
|
||||||||||||
|