Home Yellow Pages Movies Classifieds Jokes Jobs
 
  Movies
  Film Actors
  Film Actress
  Photo Gallery
  Film News
  Film Reviews
  Interview
  Movie Clips
  Downloads
  Screen Savers
  Wallpapers
  Movie Forums
  Links
  Television

 


ALL Hindi Tamil Malayalam English
$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"); ?>