Resources
Click on the boxes to expand the navigation
(MO) = members only.
Choose your level:
Basic Skills Online - Bookshop
Normal text | Big text
Coming soon: Amazon supply books at bargain prices, so we're going to be compiling a list of relevant
books in our database. You'll be able to find out about them here and if you want to, you will be able
to order them online.
SQL = " . $query);
$num_rows = mysql_num_rows($sth);
if ($num_rows==0) {
print ("
No books found.
\n");
} else {
// list the books
print ("
List of existing books:
(Click in the boxes to show or hide the book details.)
\n
");
while ($row=mysql_fetch_array($sth, MYSQL_ASSOC)) {
print ("");
print ("\n");
print (" Title: " . $row["title"] . " | Title: | ");
$url="";
if ($row["sellersurl"] != "") { $url="![Image of book](" . $row["sellersurl"] . ") "; }
print ("" . $row["title"] . "
" . $url . " | ");
print ("| Author: | " . $row["forename"] . " " . $row["author"] . " | ");
print ("| Publisher: | " . $row["publisher"] . " | ");
print ("| Classification: | " . $row["classification"] . " | ");
print ("| ISBN/Ref: | " . $row["isbn"] . " | ");
print ("| Buy this book" . " | ");
print ("Comments:
" . $row["comments"] . " |
\n |
\n");
}
print ("
\n");
}
mysql_close($dbh) or die("Couldn't close db connection: " . mysql_error());
?>
Search
Search the bookshop more specifically to find what you want:
Contribute
Suggest a book or send us a review of a book we already list:
In fact you could suggest a CD-ROM or anything that might be useful to
other people.
