Re: Problem with my Car DB
| From: | Fred | Date: | Thu, 22 Nov 2001 01:34:49 +0000 |
| Subject: | Re: Problem with my Car DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14521@lists.php.net to get a copy of this message | ||
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 <lgeise@tryi.com> wrote in message
news:20011122011232.29654.qmail@pb1.pair.com...
> 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
>
>