MySQL recordset paging logic

I have developed a routine in ASP to page through a recordset in a MySQL database using MyODBC driver, it works fine, currently like this:

[First|Prev] 1 2 3 4 5 6 [Next|Last]

However if I set to show 1 (one) record per page and if I have 100's of records, the numeric links just add up to the total number of records, making the paging area a massive set of numeric links.

What I want is for it to calculate a few links around the current page then in btw add something, like this:

[First|Prev] 1 2 3 ... 97 98 99 [Next|Last]

Does anyone knows the logic behind this? Looked everywhere, nothing, lots of info on it for ADO and paging for Access/MSSQL but MySQL driver does not support it.

Hi, I have a working routine that does just that.
As it stands it does this:

[Prev] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 [Next]

Viewing page 12 -----------------------^^

It has 25 pages, each page shows 10 records, now I don't want all those links showing, my original question was, how to make it so it will show something like this:

[Prev] 1 2 3 ... 10 11 12 13 14 ... 23 24 25 [Next]

Viewing page 12 -----------^^

Note that its nice to contain some initial pages, then also some around the currently viewed page, and at last a few of the last pages, the middle area should change dynamically as we navigate.

What's the code logic behind this? Pseudo or real code examples welcome.

I can post my working code, at this point I just want to understand the working logic so I can test around it.

Well, yes, in ASP, but the logic would probably be the same for other languanges.