I've got one of those problems that you know the problem is simple, but
you've been staring at it for too long to make sense anymore.
Basically, I have the following function to help step through a database
by displaying Previous and Next links, depending on some variable sent
to it.

function pagination($start, $num_rows,$file,$limit) {
        if(empty($limit)) {
                $limit = 20;
        }
        if($start ==0) {
                $previous_link = " ";
        } else {
                $start = $start - $limit;
                $previous_link = "<a
href=\"$file?start=$start\">Previous Entries</a>";
        }
        if($num_rows > ($start + $limit)) {
                $start = $start + $limit;
                $next_link = "<a href=\"$file?start=$start\">Next
Entries</a>";
        } else {
                $next_link = "&nbsp;";
        }
        echo "<table width=\"100%\">
                <tr>
                        <td width=\"50%\"
align=\"center\">$previous_link</td>
                        <td width=\"50%\"
align=\"center\">$next_link</td>
                </tr>
        </table>";                      
}

So $start is where to start retrieving items from the db.  $num_rows is
how many rows there are in the DB. $file is the file calling it and
$limit is how many rows per page to display.  

The problem I'm having is that when calling the function with:
pagination(5,10,"file",5); 

The next link continually displays.  This should be incorrect as 10
($num_rows) is not greater than 10 ($start + $limit.  Any suggestions
will be appreciated.

Thanks,

Conor 


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php-list/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

Reply via email to