next link displays even if no additoinal pages

[Fife_Club]

Hi. I'm a beginer at this stuff. I've got this code that will display previous and next links when displaying data from my mySQL database, x results per page. It works fine in most cases but there are a couple of problems that I'd like to adjust.

It doesn't display a previous arrow if it's on the first display page 🙂, but for any page which has at least 1 result, it always displays a next arrow , even if there is no next page :mad:. Click here to see an example of this situation

Here's the code I'm using (tell me if you need to see more of it). Can somebody please help me adjust this code slightly to avoid displaying the next link when there isn't one? I've been trying this stuff for weeks now and in my own beginer-ness I'm just not getting any of my previous attempts to work. I know you're not supposed to write code for others but I'm really desparate for fixing this one little situation. Please help! Thanks!

if(!isset($page)) { $page = 0; }
$per_page = 25;
$limit = $page * $per_page;

$query = "SELECT * FROM alumni WHERE classyear IN ($classyear) ORDER BY classyear,lastname LIMIT $limit,$per_page";
$result = mysql_query ($query);


//(bunch of stuff in this middle area that displays the page results, but I didn't want to bother you with those details)


if ($page['0']) print "<b><a href='$PHP_SELF?classyear=".($classyear)."&page=".($page-1)."'><img src=\"bleft.gif\" border=0></a></b>\n";
echo "   ";
if (@mysql_num_rows($result)) print "<a href='$PHP_SELF?classyear=".($classyear)."&page=".($page+1)."'><img src=\"bright.gif\" border=0></a></b>\n";

[werkkrew]

its because you have an if statement that displays the arrow and a link to the second page...if you are on page[0]...

you should make it like

$sql = query to make list
$results = mysql_num_rows($sql);

//To display link to Next page : current page is 1 for first, 2 for second, etc, not 0 for the first page

if(($results/$current_page) > $results_per_page)
{show link to next page}

//To display link to previous page
if($current_page > 1)
{go to previous page, only shows up if you arent on the first page}

This way, if the result is 49 and you want to show 25 results per page, if you are on page one, the if is true, if you are currently on page 2, its not, and thus, the link wont be displayed...

[Fife_Club]

Awesome. 😃 I'll try that over the weekend. That methodology (of there being a problem with the zero) is unlike anything I've tried so far, so hence it looks promising. Thanks.

[Fife_Club]

Okay, I tried it and ran into difficulty. I think I underdtand the concept of why it should work. With the names that fit my query, this is my code:

echo "<p>";
if ($page > 1) print "<b><a href='$PHP_SELF?lastname=".($lastname)."&page=".($page-1)."'><img src=\"bleft.gif\" border=0></a></b>\n"; 
echo "_ _";
if (($result/$page > $per_page)) print "<a href='$PHP_SELF?lastname=".($lastname)."&page=".($page+1)."'><img src=\"bright.gif\" border=0></a></b>\n"; 
echo "</p>";

Here's an example of the page I'm testing out. As you can see from the extra print out, the first page is now 1 instead of 0. It also prints the results per page. But for $result is just prints out "Resource id #4". I suppose this is supposed to tell me how many rows of results were returned by the querry? I replaced "$result/$page " with 100 and the next arrow reappeared so the question would be how do we 'call' the total number of result rows returned by the query (regardless of the number of rows show on each page)?