In database it shows:
-Table 1 data show discount_category_id as: 1 2 3
-Table 2 data show category_id as: ,1, ,2, ,3,
So is anything wrong or any syntax error with my code because i tried print_r but no value.
->join('LEFT', $db->quoteName('#__hikashop_discount', 'e'). ' ON (' .
$db->quoteName('e.discount_category_id') . ' LIKE "%' . $db-
>quoteName('d.category_id') . '%")')
LIKE
to match values in a comma-separated string is super bad idea. LIKE is whole-number-ignorant, so if you search for1
you will get a match if11
,8741
, or180
(etc.) is in the csv list. Let us help you -- edit your question please.