Tejas H.

You are not getting my point. I am using splitPageResults class for pagination and wants to limit the total records. Here is the code that i am using: $bestsellers_query_raw = "select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "' order by p.products_ordered desc"; $bestsellers_split = new splitPageResults($bestsellers_query_raw, MAX_DISPLAY_SPECIAL_PRODUCTS); How can i limit the no. of total records and with pagination?

Hi @YePix That isn't working and break the sql query. After adding the limit to the query, it will be like below after using splitPageResults: select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc limit 20 limit 0, 15 Notice there are two limits in the query. One from the main query and one that is generated from splitPageResults class.

Anybody have any suggestion?

Hello, I would like to know that if it's possible to limit the no. of records using splitPageResults class. For example, On my store, I have 100 special products. But i want to show only 50 special products from it. When I use splitPageResults class, it's showing all 100 products. How can i limit that to 50 products? I truly appreciate any help. Thanks Tejas

Hello, I am using PayPal Payments Standard method with following configuration: osCommerce Online Merchant v2.3.4.1 PayPal Payments Standard Version: 3.1 I know It will create pre-order when user checkout using this method. I would like to know that is it possible to prevent this? I mean is it possible to create order only if user complete order successfully through PayPal? Regards Tejas