|
echo "$language Film Reviews";
include("../config.php");
$cnx = mysql_connect($db_host,$db_user,$db_password) or die("Can't connect to database");
mysql_select_db($db_db,$cnx) or die("Can't select DB");
$sql = "select * from movies";
if($language) { $sql .= " WHERE language='$language'"; }
$result = mysql_query($sql) or die("Can't execute query".mysql_error());
# code for Next Prev.
$num_rows = mysql_num_rows($result);
mysql_free_result($result);
$result_per_page = 20;
$num_pages=intval($num_rows/$result_per_page);
if($num_rows%$result_per_page) { $num_pages++; }
if(empty($offset)) { $offset=0; }
for ($i=1;$i<=$num_pages;$i++) {
$newoffset=$result_per_page*($i-1);
if($newoffset == $offset){
$str_result_no .= "$i ";
} else {
$str_result_no .= "$i ";
}
$ii++;
if($ii==15) { $ii = 0; $str_result_no .= " "; }
}
$nav_result = "
$num_rows $language Movie Reviews Found... |
Pages: $str_result_no |
";
$sql .=" ORDER BY year DESC, id DESC";
$sql .=" LIMIT $offset,$result_per_page";
$result = mysql_query($sql) or die("Can't execute query $sql ".mysql_error());
if($myrow = mysql_fetch_array($result)){
do {
$name = $myrow["name"];
$fid = $myrow["fid"];
$cast = $myrow["cast"];
if($seo_url == "yes") {
echo "$name - $cast ";
} else {
echo "$name ";
}
} while($myrow=mysql_fetch_array($result));
echo "$nav_result";
} else {
echo "No Movies Found";
}
include("./footer.php");
?>
| |