$pagetitle="Travel Book Reviews";
require "$DOCUMENT_ROOT/include/common.inc";
require "$DOCUMENT_ROOT/include/dbcommon.inc";
#require "$DOCUMENT_ROOT/include/email.inc";
StartPage($pagetitle,"");
if (!$reviews)
$reviews="yes";
?>
Travel Book Reviews
I am constantly buying books for information on roadside attractions. A well-stocked library is not only helpful but provides hours on enjoyment.
Links to purchase them are provided in association with Amazon.com, but you can read the reviews without visiting the Amazon.com site.
|
if ($reviews == "no")
print "show all reviews
";
else
print "
hide reviews
";
print "
\n";
db_open_read();
$results = mysql($dbName,"SELECT * from books order by rating desc");
$bookcount = mysql_num_rows ($results);
for ($i=0;$i<$bookcount;$i++){
$btitle = mysql_result($results,$i,"title");
$bsubtitle = mysql_result($results,$i,"subtitle");
$bauthor = mysql_result($results,$i,"author");
$bASIN = mysql_result($results,$i,"ASIN");
$breview = mysql_result($results,$i,"review");
$bURL = mysql_result($results,$i,"URL");
$brating = mysql_result($results,$i,"rating");
$bimage = mysql_result($results,$i,"image");
print "";
if ($bimage)
print " | \n";
else
print " | \n";
print "";
print "\n";
if ($bsubtitle)
print " $bsubtitle \n";
print "by $bauthor \n";
if ($bURL)
print "\n";
print "";
for ($j=0;$j<$brating;$j++)
print "  ";
print " \n";
if ($reviews != "yes" and $reviews !="$i")
print "";
print " | ";
print "
";
if ($reviews == "yes" or $reviews == "$i"){
if (!$breview)
$breview = " ";
print "$breview |
\n";
print " |
\n";
}
}
print "
\n";
copyright("2000","");
EndPage();
?>