hi dude yeh u have to append the page query to the current query , here is an example of my db class
http://electroteque.dyndns.org:1023/benchmark/DB.phps down the page is the pagination u want in particular the url function -----Original Message----- From: Stitchin' [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:20 AM To: [EMAIL PROTECTED] Subject: Recordset paging with php on mySql database ... works on first page but ... I had asked the group previously about limiting the results shown on my website to a certain number and then navigating to the next group etc... I found a great article by Joe O'Donnell called "Building A Dynamic MySql Paging Class with PHP" ... I created his example and it worked fine. Then I started changing his example and tried to use it with my database using a query where the web visitor selects a catagory of designs to display. The catagory has 24 designs and I'm paging 6 at a time. The first page comes out fine and it has the navigation buttons on the bottom for the other pages ...but when I try to navigate to any of the other pages, I get nothing AND the catagory selected disappears from the heading of the page. In the document that holds this html code, I do have the line, $interest = $_POST['interest']; to make sure that the visitor's selection from the previous page comes forward and the initial query is getting the correct results. Is there anybody out there who would be willing to look at my code and see what is happening and why I don't get any results from succeeding pages? This is the very last thing I need to finish my website and I'm so frustrated ... I know the example works and I know I'm getting some results but I just have no idea where to go from here ... I would be SOOOOO GRATEFUL ... please email me at [EMAIL PROTECTED] if you can take a moment to help me. Humbly begging for help, Renee Toth Stitchin' Up A Storm www.stitchinupastorm.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
