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;
}
?>The Raven (Poetry, Short Stories, Gothic, Horror, Mystery, Adaptation)


 PLOT: Little is known about the last days of dark poet Edgar Allan Poe's (John Cusack) life but according to this story it was anything but pleasant. He spends those days accompanying young Detective Fields around Baltimore in an effort to help him track down a killer who is basing his murders on Poe's literary works. With his only love at stake, his creative writing is truly put to the test. BOOK TITLE: Complete Stories and Poems of Edgar Allan Poe AUTHOR: Edgar Allan Poe

|
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
|