Home > Archive > PHP SQL > March 2005 > help display mysql records
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
help display mysql records
|
|
| Spyril Cheng 2005-03-26, 8:57 am |
| 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
| |
| David Robinson 2005-03-26, 3:56 pm |
| "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.
|
|
|
|
|