Previous Next Button Sort Problem

[pablomontanero]

I installed the contribution Previous_Next Button 3.2:

 

http://addons.oscommerce.com/info/1164

 

The contribution show a previous and next button in the product info window.

My problem is that when you click one of the button, it jumps to the next

product according to product id instead of product name. It seems to be a

sorting problem in the following code of the file products_next_previous.php.

 

$products_ids = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc where p.products_status = '1'  and p.products_id = ptc.products_id and ptc.categories_id = $current_category_id");

 

Can somebody please help me with this?

 

Cheers

 

Richard