Feyd, I have been using your code for the next page function for sometime now, worked great, UNTIL now....
Perhaps you can help me.
From my main page if you were to detect on this link, the variable type is passed to mypager.php.
<a href="http://host37.ipowerweb.com/~southern/mypager.php?type=comedy"><img align="center"
src="comedy.gif" alt="Comedy Flicks" border="0"></a>
Now mypager.php will display the proper number of things on the first page(limit set to 4, 6 items in the database, should have 2 pages of stuff to display and I do).
The problem is when I ask it for the next page(should be 2 more) I get nothing displayed.
I can get it to work by hardcoding the variable to ($type=comedy)
in mypager.php. Is the variable getting lost on the second page?
My simple mind cant figure this out.
Any ideas........ Thanks in advance
code:
mysql_select_db ("southern_newreleases",$linkID);
//$db = mysql_select_db($dbName,$dbConnect) or die('Unable to SELECT Database : '.mysql_error());
$per_page = 4; //amount to display on each page
//$lookup_type=$_GET['type'];
//$_PUT['lookup_type'];
//$ID=$_GET['ID'];
//print "$type";
//$type = comedy;
//switch ($lookup_type)
// {
// case "comedy":
// $type = "$lookup_type";
// print "$type";
// break;
// }
$sql_text = ("SELECT iloc,dloc,movie_name,director,actor,date,rated,num_stars FROM movies
WHERE type='$type'");
$result_count = @mysql_query($sql_text);
$totalrows = @mysql_num_rows($result_count); //get counts prior to pagination
if (empty($page)) @$page = 1;
$limitvalue = @$page * $per_page - ($per_page); // Ex: (2 * 25) - 25 = 25 <- data starts at 25
$sql_text = $sql_text . ' LIMIT ' . $limitvalue.', ' . $per_page; //break into paged sections
$query = mysql_query($sql_text) or die('Error: ' . mysql_error());
//content code display here
// print "limit valve = $limitvalue";
// print "per_page = $per_page";
// print "totalrows = $totalrows";
while (list($iloc,$dloc,$movie_name,$director,$actor,$date,$rated,$num_stars) = mysql_fetch_row($query))
{
print "<tr><td valign=middle align=left colspan=7>";
print "<img align=left valign=middle src=$num_stars>";
print "<strong>     Directed by
$director</strong>      ";
print "<strong><font color=#ffff00>$movie_name ($date)   </strong></font>";
print "<strong>    Starring $actor </strong>";
print "<img align=right valign=top src=$rated>";
print "<hr align=right size=1 color=#ffff00 width=100%></td></tr>";
print "<tr bgcolor=#c4b79d>";
print "<td height=110>";
print "<img align=center valign=middle src=$iloc width=93 height=130></td>";
print "<td valign=middle align=center>";
print "<strong>";
readfile("$dloc");
print "</strong>";
print "</td></tr>";
print "<tr><td height=1 colspan=4><img align=left valign=bottom src=rent.gif width=38 height=
18>";
print "<hr align=right size=1 color=#ffff00 width=100%>";
print "</td></tr>";
}
print "<table width=760 align=center border=0>";
print "<tr>";
print "<td align=center>";
print "<h3>";
print "<strong>";
//actual pagination build of links
//previous
if ($page != 1) {
$pageprev = $page - 1;
echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$pageprev.'"><<Previous</a>';
} else //no previous or add unavailable option, or remove else completely
//active pages
$numofpages = $totalrows / $per_page;
// print "Active number of pages=$numofpages";
for($i = 1; $i <= $numofpages; $i++) {
if ($i == $page)
{
echo ' '.$i;
//
}
else echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'">'.$i.'</a>';
}
//check for remaining rows, if no page available after prev block
if (($totalrows % $per_page) != 0) {
if ($i == $page) echo ' .$i';
else
echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'">'.$i.'</a>';
}
//next
if( ($totalrows - ($per_page * $page)) > 0) {
$pagenext = $page + 1;
echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$pagenext.'">>>Next</a>';
}
else //print "in the damm else";
//} else no next or add unavailable option, or remove else completely
mysql_free_result($query); //paranoid cleaner
print "</h3>";
print "</strong>";
print "</td>";
print "</tr>";
print "</table>";
mysql_close($linkID);
?>
Before you post, read our: 
I was just looking for something like that
