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
[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
> the car db here so far
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]