jack wu wrote:
i am trying to run some web search like query. the one
that returns a total number of results and only
presents the first 20, then allows user to click on
next to go to the next 20 etc.
has anyone done this before? i suppose i would use
LIMIT or OFFSET in the select statement,
You should use SQL to get the data you want, then use
your host language to display the data. Those are 2
separate operations, and you'll be better off not mixing
them. If you're going to let your users go backward,
you're going to have to cache the data anyway.
Regards
i am trying to run some web search like query. the one
that returns a total number of results and only
presents the first 20, then allows user to click on
next to go to the next 20 etc.
has anyone done this before? i suppose i would use
LIMIT or OFFSET in the select statement, but the
offset
3 matches
Mail list logo