html >> MySQL, PHP pagination

by BrianG61 » Tue, 03 Jan 2006 02:54:19 GMT

Hi guys, Happy New Year!

I'm building a site promoting products. The information for the products are
stored in a database. I have no problem connecting to or retrieving from this
database. My problem is I only want to display 15 products at a time on the
page creating x number of pages. I have my products ordered by upload date. How
do I page through the rest of the products? I've tried using the server
behavior (repeat region, move to page..., etc) tools in dwmx, but I've not been
successful. Can anyone help?

Brian



Similar Threads

1. [PHP] About PHP/MYSQL Pagination - PHP

2. Dreamweaver MX PHP MYSQL Paging Pagination

3. php pagination with MySQL - Adobe Dreamweaver

4. About PHP/MYSQL Pagination

I just couldn't find it anywhere, google or yahoo. I know how to make 
first, previous, last, and next links for php/mysql pagination. How do 
you list page numbers in the middle, between previous and next? (ex. << 
first previous | 1 2 3 4 5 | next last >> )

I know how to display them from 1 to whatever by using for loop, but the 
problem comes in when I click "next" from page "5", it does not get 
re-listed starting from page "6".

5. mysql queries + pagination - PHP

6. Passing PHP form data with pagination

Using PHP & MySQL - I have a search form with several criteria for searching a 
database.  I pass the form variables to another PHP page that displays the 
recordset nicely.  It's great until I try to limit the recordset to display 
only the first 25 or so records & add pagination using the "move to next page" 
server behavior.  It loses the search criteria the user submitted & considers 
the entire database, not just the queried records that match the search 
criteria.   

 How do I retain those criteria through the remaining page views of the 
recordset displayed on that page?

 Thanks,  Wick Smith

7. i love php but php loves mysql and mysql hates me - Adobe Dreamweaver

8. [PHP] split in to multiple pages ( pagination)