Product Discount Display

[jimmie]

example: https://jnsflooringandsupplies.com/T...Grouting_Float, ZC Version 1.56c,
i have this

// base price
                if ($show_onetime_charges_description == 'true') {
                    $one_time = '<span >' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
                } else {
                    $one_time = '';
                 }
                $cheapest = zen_get_products_discount_price_qty((int) $_GET['products_id'], 20000);
                $cheapest = '$' . number_format($cheapest, 2);
                $price = zen_get_products_actual_price((int) $_GET['products_id']);
                $price = '$' . number_format($price, 2);
                $bulkqty = $products_discounts_query->fields['discount_qty'];
				$bulkpercent = round($quantityDiscounts[$columnCount]['discounted_price'] = $products_discounts_query->fields['discount_price']);
                if ($cheapest != $price && (!stristr($price, "productSpecialPrice") ) && (!stristr($price, "call_for_prices") && ($calculator == 1))) {
                    echo 'Buy&nbsp;'. $bulkqty . '&nbsp;Sq.&nbsp;Ft.&nbsp;for&nbsp;' . $cheapest .'&nbsp;and&nbsp;save&nbsp;' . $bulkpercent.'%';
              } else if ($cheapest != $price && (!stristr($price, "productSpecialPrice") ) && (!stristr($price, "call_for_prices") && ($calculator == 2))) {
                    echo 'Buy&nbsp;'. $bulkqty . '&nbsp;Sq.&nbsp;Ft.&nbsp;for&nbsp;' . $cheapest .'&nbsp;and&nbsp;save&nbsp;' . $bulkpercent.'%';
                 } else if ($cheapest != $price && (!stristr($price, "productSpecialPrice") ) && (!stristr($price, "call_for_prices") && ($calculator == 0))) {
                    echo 'Buy&nbsp;'. $bulkqty . '&nbsp;for&nbsp;' . $cheapest .'&nbsp;each&nbsp;and&nbsp;save&nbsp;' . $bulkpercent.'%';
                 }
                ?>

code to display my discounts like this
Buy 60 for $8.92 each and save 8%
but this does not show all discounts, just the last 1 in list.
based on code above what do i need to add to it to make it show all fields in discount table?

[carlwhat]

jimmie,
your code is.... well.... u know...

there is no need for this var $products_discounts_query->fields[whatever] in this code. that is just taking the last record used.

what you need is the var $quantityDiscounts, which you only use once, and in fact you end up replacing it with the above var.

u need a loop as $quantityDiscounts is an array that contains all of your data.

i'm just not sure why you are not using:

includes/templates/template_default/templates/tpl_modules_products_quantity_discounts.php

which will output all of the discounts.

if you want to do it in your above code, you need to do something like:

         foreach ($quantityDiscounts as $discount) {
                                  
                   // do stuff with $discount, ie all of your calculations and then echoing to the screen.
                   // the next line will help you see....  hopefully
                 print_r($discount);
         } 

hope that helps.

best.

[jimmie]

im sorry not understanding where to put your code. i tried but it prints it out as inputted in database, trying to style as my code