Multi Cross Sell mod [Support thread]

[andreitero]

Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
 from " . TABLE_PRODUCTS_XSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
 where xp.products_id = '" . $_GET['products_id'] . "'
  and xp.xsell_id = p.products_id
  and p.products_id = pd.products_id
  and pd.language_id = '" . $_SESSION['languages_id'] . "'
  and p.products_status = 1
 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);

Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:

1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]

Do you have any other suggestions i should try?
Thanks for taking the time.

[gilby]

Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:

1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]

Do you have any other suggestions i should try?
Thanks for taking the time.

Ahh.. Try this one:

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
 from " . TABLE_PRODUCTS_MXSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
 where xp.products_id = '" . $_GET['products_id'] . "'
  and xp.xsell_id = p.products_id
  and p.products_id = pd.products_id
  and pd.language_id = '" . $_SESSION['languages_id'] . "'
  and p.products_status = 1
 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);