Navigation through DB Queries
| From: | Phillip S. Baker | Date: | Fri, 27 Oct 2000 22:15:21 +0000 |
| Subject: | Navigation through DB Queries | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-22384@lists.php.net to get a copy of this message | ||
Okay I am pulling x number of records from a DB and displaying them.
And I want to display only 50 of those records on a page.
I get setting something like an $x and $y variable $x = 0 $y = 50
SelectStmt = "....Limit $x,$y"
Now at the bottom of the page I want to create a navigation so the user can click on over to the next 50 records or back to the previous 50 records. How would I write something like this?
Thanks in advance.
Phillip S. Baker
phillip@wordsandimages.com
Words & Images
1535 Seabright Avenue, Suite 100, Santa Cruz, CA 95062
Direct Line (831) 420-2641 / Fax (831) 458-0808