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=1 ORDER BY series ASC "); ?>
|
|||||||||||||
Star Trek The Original Series (TOS) BooksSome of the best science fiction writers over the past few decades have contributed their literary talents to the Star Trek book collection. These include the works of Vonda McIntyre, Diane Carey, Judith and Gar Reeves-Stephens, Michael Jan Friedman and even Gene Roddenberry. If you are a real fan of Star Trek "The Original Series" you can usually find one of the episodes being broadcast on a television set somewhere at some time. Or, you can go to a book store, the local library, or log on to amazon.com and find an original series book. Even though the Star Trek Original Series has long been off the air as a weekly series, there is still a soft spot in the heart of the true fan who wants to know what happened before, during, and after our friends aboard the Enterprise popped off into warp one last time. We are going to review as many of them as we can, as well as the technical manuals and everything else we can find. We hope you will enjoy our Star Trek Original Series book collection and invite you to add your favorites to the list. while ($myrow = mysql_fetch_row($series)) { echo("$myrow[0]"); echo("
|
|
||||||||||||
|