just add "LIMIT N,R" to your SELECT statement where N is the row you want to
start with and R is the number of rows you want to fetch.

The first row is 0 so if you want to fetch 10 cars per page make R 10 and
make N a variable.  Pass 0 to N on the first pass, then put links on your
page for NEXT where N=N+10


Lynn Geise <[EMAIL PROTECTED]> wrote in message
> Can someone give me the code to make the db display 10 cars per page then
> make another page with the links below the car for the next page youc na
> the car db here so far
> http://www.games-are-forever.com/phpadmin/cardisplay.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to