On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
> Hello,
>
> we've set up many displays using the "Previous" and "Next" simple linking
> set up of search results. But now would like to implement the page number
> style, IE. "Previous" [1] [2] [3] "Next" style format and was hopi
s per page.
- Original Message -
From: "Jesse Sheidlower" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 4:41 PM
Subject: Re: Page Numbers
: On Wed, Nov 1
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
> Hello,
>
> we've set up many displays using the "Previous" and "Next" simple linking
> set up of search results. But now would like to implement the page number
> style, IE. "Previous" [1] [2] [3] "Next" style format and was hoping
I have a function that accepts a page number and an amount per page value
then generates the numbers for the LIMIT clause. It requires
SQL_CALC_FOUND_ROWS to be specified in the query.
iNum=10; // Rows per page
iPage=1; // Current page, first page is 1
iStart= (iPage-1) * iNum; // Starting row num
