> I am developing a web site that interacts with a MySQL database. When I
run
> a query and display the records in a web page, this can become a problem
> because there might be too many records to be displayed in one single web
> page so I am trying to divide the total number of records and display them

> in multiple pages. Let's say, if the query returns 100 records then I
would
> like to display the first 10 records and then put a navigation bar where I

> can go to the next 10 or return to the previous 10 records
>
> Is this done at a SQL or PHP level ? any experience on doing this ?

This is called pagination, and is well-discussed and documented on the web:

http://www.google.com/search?q=php+pagination

--
Jared Farrish
Intermediate Web Developer
Denton, Tx

Abraham Maslow: "If the only tool you have is a hammer, you tend to see
every problem as a nail." $$