help display mysql records

hey everyone
i have a problem and i don't know how to do it.

right now i'm making a web site, and it connect to a mysql database, the
database has customer information, such as name address, phone number, and
there's thousands records in the database.
and i want to display the customer record, 20 records per page, and i want
to have a link that gos to the next page (next 20 records) after that, i
know how to display the first 20 record, but i don't know how to display the
next 20 after that using the link or even the 100th record after that. can
some one help me out here please thanks alot

"Spyril Cheng" <spyril@iinet.net.au> wrote in message
news:42452bc1$0$16013$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> hey everyone
> i have a problem and i don't know how to do it.
>
> right now i'm making a web site, and it connect to a mysql database, the
> database has customer information, such as name address, phone number, and
> there's thousands records in the database.
> and i want to display the customer record, 20 records per page, and i want
> to have a link that gos to the next page (next 20 records) after that, i
> know how to display the first 20 record, but i don't know how to display
> the
> next 20 after that using the link or even the 100th record after that. can
> some one help me out here please thanks alot
>

Have a look at the LIMIT option at mysql.com.