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 Fred Lynn Geise <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 see > 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]