paging not working properly

winey

I'm having trouble with the paging section of a script that I've used successfully before.
Here's the site:

http://www.lissadesigns.com
Click on the 'Pansy' collection and then try the 'next' or '2' link at the bottom. It shows the correct variables passing through ($start, $num_results, and $num_pages), but it just shows the first 10 items again instead of the next nine that should show. Here's the paging section of the script:
// Make the links to other pages, if necessary.
if ($num_pages > 1) {
echo '<div align=center> ';

// Determine what page the script is on.
if ($start == 0) {
$current_page = 1;
} else {
$current_page = ($start/$display_number) + 1;
}

// If it's not the first page, make a Previous button.
if ($start != 0) {
echo '<a href="jewelrycollections.php?start=' . ($start - $display_number) . '&collectionname=' . $collectionname . '&num_pages=' . $num_pages . '&num_results=' . $num_results . ' ">Previous</a> ';
}
// Make all the numbered pages.
for ($i = 1; $i <= $num_pages; $i++) {
$next_start = $start + $display_number;
if ($i != $current_page) { // Don't link the current page.
echo '<a href="jewelrycollections.php?start=' . (($display_number * ($i - 1))) . '&collectionname=' . $collectionname . '&num_pages=' . $num_pages . '&num_results=' . $num_results . ' ">' . $i . '</a> ';
} else {
echo ' ' . $i . '' . ' ';
}
}

// If it's not the last page, make a Next button.
if ($current_page != $num_pages) {
echo '<a href="jewelrycollections.php?start=' . ($start + $display_number) . '&collectionname=' . $collectionname . '&num_results=' . $num_results . '&num_pages=' . $num_pages . ' ">Next</a> ';
}

Any ideas why this isn't working correctly? http://www.lissadesigns.com

milind24

Your coding is ok for paging but I think your problem is in query where u fetching a record , there u used the Limit Statement not
working properly ,may be u r not chaged it try your query as

select * from table name where condition order by fieldname LIMIT startfrom,displaylimit

try check startfrom is ok

winey

As I was falling asleep last night, the answer came to me:
Unlike previous uses of this paging script, this time I'd written it as a function and put it in an include file--what I'd neglected to do was feed the $start, $num_pages, and $num_results variables into the function along with the collection name variable. Once I did that this morning, all worked perfectly.

Thanks.