Re: Problem with code
| From: | Greg Donald | Date: | Mon, 06 Dec 2004 15:36:20 +0000 |
| Subject: | Re: Problem with code | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-203599@lists.php.net to get a copy of this message | ||
On Sun, 5 Dec 2004 21:05:12 -0800, Richard Kurth <rdkurth@directphp.com> wrote:
> I am having a problem with the code below it provides the first page
> with out any problem but when I select the next page it shows all the
> results from the first page and the results from the second page. It
> does the same thing on the third page also. I have been looking at it
> for two days and can not fined the error in the code
It's probably the LIMIT clause in your sql query. Try printing the
sql query on the page and check the limit.
Or use one of the existing pagination classes from PEAR:
http://pear.php.net/package-search.php?pkg_name=page
--
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/