Hi tony i have tried these and none of them work for me. When i active the manufacturers_img mod it shows up with this code :-

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOX_MANUFACTURER_MAX_LOGOS' at line 6
in:
[select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1') ORDER BY RAND() LIMIT 0,BOX_MANUFACTURER_MAX_LOGOS]

What am i doing wrong ?