i index.php finder du
[php]<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>[/php] og ved at udkommentere med // som du har gjort så burte det forsvinde..
HUSK at der henvises til "FILENAME_NEW_PRODUCTS" mere end et sted.
og.. jeg mener osse at der er en henvisning til de nye produkter i en anden fil.. men dette er jeg dog ikke sikker på...
BlackCap
EDIT:
Der er en fejl i din sql streng i Vis alle produkter
[php]1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select p.products_id, p.products_model ,pd.products_name, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name
[/php]
mener at det skal være
[php]select p.products_id, p.products_model ,pd.products_name, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from (products p , categories c, products_to_categories p2c) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name
[/php]
og mener at det er fordi din mysql version er 5.x
Det eneste der mangler er ( ) rundt om selve FROM delen
BlackCap