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 = 6 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 = 6 GROUP BY officer.officerID ORDER BY total DESC LIMIT 4 "); $series = mysql_query(" SELECT series, seriesID FROM library_series WHERE subgenreID=39 ORDER BY series ASC "); ?>
|
|||||||||||
"Good Books" Book ReviewsThe Good Books section welcomes book reviews from such topics as the Classics; Action and Adventure stories and series; Historical novels; Murder and Mysteries; and books that may be classics in another language or country; and books that you have had to read and report for school, university or a special project. We welcome all those books and new readers and reviewers to join the Outpost Library team. Go to the Library home page and click on the "here" text link on the right side of the page. Everything you need to know to read and write for us is there. Lets make "Good Books" as successful as the rest of the sections! while ($myrow = mysql_fetch_row($series)) { echo(" $myrow[0]"); echo("
|
|
||||||||||
|