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 = 5 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 = 5 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=12 ORDER BY series ASC "); ?>
|
|||||||||||
Science Fiction "Alternate Universes" BooksWhat is an Alternate Universe? A place that is not part of our known solar system, inhabited by strage beings, some human and some not. Places that are not on our astronomical charts, and out of reach in this time. Who is to say that these places and people do not exist - we won't know until we can travel to those places where some of the best of the best Science Fiction is set in landscapes and mindsets unknown to man. In the Alternate Universes, time travel is not uncommon. Just ask Dr. Who or the inhabitants of the planet called Dune. Venture into the world of L.M. Bujold and visit the Vorkos series - you have no idea what you'll find there, but it won't be familiar earth-based storytelling. We all know that Terry Pratchett has a way with strange places - take a look and see what he has imagined! while ($myrow = mysql_fetch_row($series)) { echo("$myrow[0]"); echo("
|
|
||||||||||
|