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 many 'buttons' you require
to get all results.
hope this helps.
len.
-----Original Message-----
From: Andres M.V. Paglayan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 20 March 2001 12:47
To: MySQL
Subject: Split results
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 the yahoo,
Best wishes for you all.
Thanks in advance.
------------------------------------------------------
Andrés Mariano Vazken Paglayan
[EMAIL PROTECTED]
------------------------------------------------------
