Hi,
As I had great success with my last query I wonder if anyone could help me with paginating results.
As you may remember I have a TV programmes site and you can display programmes by genre (i.e comedy,drama etc) Wheras some genres spring out loads of results other don't produce that many.
I wonder if you can help me split the results into seperate pages. Say 15 results per page. How can I achieve this?
The current coding I have is:
function showProgsGenre($genre) {
if ($genre == "childrens") {
$sql = "SELECT FROM progs WHERE genre_childrens = '1' ORDER BY 'title'";
} elseif ($genre == "all") {
$sql = "SELECT FROM progs ORDER BY 'title'";
} elseif ($genre == "comedy") {
$sql = "SELECT FROM progs WHERE genre_comedy = '1' ORDER BY 'title'";
} elseif ($genre == "documentary") {
$sql = "SELECT FROM progs WHERE genre_documentary = '1' ORDER BY 'title'";
} elseif ($genre == "gameshow") {
$sql = "SELECT FROM progs WHERE genre_gameshow = '1' ORDER BY 'title'";
} elseif ($genre == "talkshow") {
$sql = "SELECT FROM progs WHERE genre_talkshow = '1' ORDER BY 'title'";
} elseif ($genre == "science") {
$sql = "SELECT FROM progs WHERE genre_science = '1' ORDER BY 'title'";
} elseif ($genre == "lifestyle") {
$sql = "SELECT FROM progs WHERE genre_lifestyle = '1' ORDER BY 'title'";
} elseif ($genre == "drama") {
$sql = "SELECT FROM progs WHERE genre_drama = '1' ORDER BY 'title'";
} elseif ($genre == "cartoon") {
$sql = "SELECT FROM progs WHERE genre_cartoon = '1' ORDER BY 'title'";
} elseif ($genre == "soap") {
$sql = "SELECT FROM progs WHERE genre_soap = '1' ORDER BY 'title'";
} elseif ($genre == "music") {
$sql = "SELECT FROM progs WHERE genre_music = '1' ORDER BY 'title'";
} else {
echo ("There was an error: Error Code DB-G-01");
}
$result = mysql_query($sql) or die ('Error Code DB-G-02');
$num = mysql_num_rows($result);
if ($num != "") {
while ( $rows = mysql_fetch_array($result) ) {
$prog_id = $rows["prog_id"];
$title = $rows["title"];
$channel = $rows["channel"];
$first_shown = $rows["first_shown"];
echo ("<a href=\"show.php?prog_id=$prog_id\"><img src=\"../bullet8.gif\" width=\"8\" height=\"8\" hspace=\"5\" border=\"0\" align=\"bottom\"><strong>$title</strong></a> : ($first_shown) : $channel<br>");
}
} else {
echo ("No programmes of this type yet sorry.<br> We always welcome new additions to the site though, please suggest a programme, by pressing contact above.");
}
}
