echo $disp_year; ?> Movies Based on BooksRead the Book Before You See the Movie. Which is better? You decide. Browse movies based on books.
$book1 = "";
$book2 = "";
$book3 = "";
$book4 = "";
$book5 = "";
if($year == 2008)
{
$book1 = 1243;
$book2 = 1247;
$book3 = 1257;
$book4 = 1160;
$book5 = 1273;
}
else if($year == 2013)
{
$book1 = 1439;
$book2 = 1430;
$book3 = 1442;
$book4 = 1441;
$book5 = 1438;
}
else if($year == 2012)
{
$book1 = 1407;
$book2 = 1408;
$book3 = 1389;
$book4 = 1409;
$book5 = 1419;
}
else if($year == 2011)
{
$book1 = 1362;
$book2 = 1335;
$book3 = 1364;
$book4 = 1368;
$book5 = 1366;
}
else if($year == 2010)
{
$book1 = 1291;
$book2 = 1296;
$book3 = 1350;
$book4 = 1311;
$book5 = 1343;
}
else if($year == 2009)
{
$book1 = 1197;
$book2 = 1270;
$book3 = 1235;
$book4 = 1223;
$book5 = 1234;
}
else if($year == 2007)
{
$book1 = 1155;
$book2 = 1152;
$book3 = 1165;
$book4 = 1144;
$book5 = 1151;
}
else if($year == 2006)
{
$book1 = 1087;
$book2 = 1090;
$book3 = 1092;
$book4 = 1084;
$book5 = 1111;
}
else if($year == 2005)
{
$book1 = 1018;
$book2 = 1047;
$book3 = 1035;
$book4 = 1041;
$book5 = 1015;
}
else if($year == 2004)
{
$book1 = 60;
$book2 = 54;
$book3 = 52;
$book4 = 57;
$book5 = 68;
}
else if($year == 2003)
{
$book1 = 30;
$book2 = 3;
$book3 = 11;
$book4 = 6;
$book5 = 19;
}
else if($year == 2002)
{
$book1 = 117;
$book2 = 108;
$book3 = 106;
$book4 = 100;
$book5 = 86;
}
else if($year == 2001)
{
$book1 = 152;
$book2 = 124;
$book3 = 143;
$book4 = 167;
$book5 = 120;
}
else if($year == 2000)
{
$book1 = 176;
$book2 = 191;
$book3 = 183;
$book4 = 200;
$book5 = 189;
}
?>Watchmen (Comic Book, Superhero, Murder, Friends, Investigation, Adaptation)


 PLOT: Watchmen is based on the graphic novel of the same name, which critics often herald as the greatest comic ever written. The story is as sophisticated as any novel. The setting is a gritty and alternate 1985, a time when the glory days of costumed vigilantes have been brought to a close by a government crackdown. However, after one of the masked veterans is brutally murdered, an investigation into who is responsible begins. The reunited heroes set out to prevent their own destruction, but in doing so they discover a deeper and far more diabolical plot. AUTHOR: Alan Moore

|
echo "" . $disp_year . " Movies Based On Books List"; ?> |
| Movie Title | Book Title | Author |
/* if ($HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"] != "")
{
$IP = $HTTP_SERVER_VARS["HTTP_X_FORWARDED_FOR"];
}
else
{
$IP = $HTTP_SERVER_VARS["REMOTE_ADDR"];
}
if ($IP == "")
{
$IP = GetHostByName($REMOTE_ADDR);
} */
if ($bbuserinfo['userid'] == 1)
{
$admin = "klance1";
}
if ($year >= 1980)
{
$query = "SELECT * FROM books WHERE year = '$year' ORDER BY movie";
}
else
{
$lowbnd = $year/10;
$lowbnd = floor($lowbnd) * 10;
$highbnd = $lowbnd + 10;
$query = "SELECT * FROM books WHERE year >= '$lowbnd' && year < '$highbnd' ORDER BY movie";
}
$result = mysqli_query($connection, $query);
// display result rows alphabetized by movie title
$j=0;
while ($row = mysqli_fetch_array($result))
{
$bookid = stripslashes($row['book_id']);
$mov_year = stripslashes($row['year']);
$movie = stripslashes($row['movie']);
$book = stripslashes($row['book']);
$book_year = stripslashes($row['book_year']);
$author = stripslashes($row['author']);
$bookasin = stripslashes($row['bookasin']);
echo " ";
if ($bookasin)
{
echo "";
}
if ($mov_year < 1980)
{
echo $movie." (".$mov_year.")";
}
else
{
echo $movie;
}
if ($bookasin)
{
echo "";
}
if ($admin == "klance1")
{
echo " (edit)";
}
echo " | ".$book;
if ($book_year)
{
echo " (".$book_year.")";
}
echo " | ".$author." | ";
$j++;
} ?>
A good book is the best of friends, the same today and forever.
~Martin Farquhar Tupper
|