"action","adventure","comedy","crime","horror","music","scifi","kids","television","fighting","other"); if (isset($_GET["cat"])) { $catnum = $_GET["cat"]; $catname = $catnames[$catnum]; } else { $catnum = 9; $catname = "television"; } if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page = 1; } $perpage = 15; if ($page > 1) { $start = $perpage * $page; $end = $start + $perpage; } else { $start = 1; $end = $perpage; } $querystr = "SELECT * FROM $catname"; $queryget = mysql_query($querystr) or die("mySQL Query Failed"); $total = mysql_num_rows($queryget) or die("mysql num row failed"); ?>

Browse by Category: Action Adventure Comedy Crime Horror Music Sci-Fi Kids Television Fighting Other All Action Adventure Comedy Crime Horror Music Sci-Fi Kids Television Fighting Other> << "; if ($page > 1) { $prevpage = $page - 1; $nextpage = $page + 1; echo "Previous  |  "; if ($end < $total) { echo "Next >> "; } else { echo "Next >> "; } } else { echo "Previous  |  "; echo "Next >> "; } echo " "; } nav(); echo "\n"; echo "\t\n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\n"; echo " Type  Title Discs \n"; $i = 0; while ($row = mysql_fetch_array($queryget)) { if ($i >= $start && $i <= $end) { echo "\t\n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\t\n"; } elseif ($i > $end) { break; } $i++; } echo " $row[title] $row[discs] \n"; nav(); ?>