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;
}
?>One for the Money (Action, Crime, Fiction, Comedy, Adaptation)


 PLOT: After getting divorced due to her husband's infidelity, fired from her job as a buyer and struggling to pay her monthly expenses, Stephanie Plum (Katherine Heigl) decides that she needs to make some big changes. Turning to her bail bondsman cousin Vinnie and blackmailing him, she is able to land herself a job which sends her on the hunt for former romance gone awry Joe Morelli (Jason O'Mara). Will she get her man? AUTHOR: Janet Evanovich

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