On Mon, 19 Mar 2001, Andres M.V. Paglayan wrote:
> Hi you all,
> I´m trying to resolve how to manage a large resultset (about 500),
> showing only 20 rows per page and then to have the option to show more results from
>several buttons,
> like when you search something with a lot of pages in
You can use the 'limit' construct on the end of the select statement.
So for first query do
select blah from blah where blah limit 20;
each succeeding query will be
select blah from blah where blah limit 20,20;
check the doco for explanation.
You can do a count to start with to determine how
I think that this is highly dependant on the language you are using to
display your results; you would probably get more help if you included that.
Good luck,
Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
P: 703-566-3196
http://www.beridney.c