get discount_id

Hi dear
I need get product discount_id from #__hikashop_discount table in database.
how can get discount_id a product use which discount?
thank you

Hi,

It depends on your discount.
You can have discount apply on a single product or discount applyed on categories (and sub categories too).

So the way to retrieve them is different depending the discount configuration.

We will need more details in order to answer you correctly.

Regards,

Thank you dear Jerome
My discount apply on a single product and I create many discount and a single product use a one discount.
now I need get discount_id for each product. how can get it?

I use this code and its work now