Display result from db onto webpage

[Sl1ver]

How to display the result set in a webpage:

1. retrieve data from the database
2. i take it, i create a loop that creates tables with data in it for every record

my question is, how on a java developed website will i get the top 10 results and create a link for every 10 results after that ( so there is only 10 visible results on every page)

[jkmyoung]

What type of database is it? MSSQL, MYSQL?

I would structure your query (or sql connection variable) to only get the first 10 results.

[Sl1ver]

mssql, ok, but how would the user know if there are more than 10 results or not?

[jkmyoung]

Run a seperate query:
select count(1) from table where condition.
Divide that by 10 (roundup) to get your total number of pages.

[Sl1ver]

OK thats understable but how would i actually make it so that a user can move to the next 10 or previous 10 results?

[jkmyoung]

Use the OFFSET keyword, keeping LIMIT to 10.