New Low Price

[collectables]

I hope someone can help me with this one. I am trying to install the 'New Low Price' Contribution, by Quentin Bennett. The problem is here:

--------------------------------------------------------------------------------
7. catalog/index.php

Several places, $listing_sql is constructed. Where you find p.products_price, add

p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL ".NLP_DAYS." DAY) nlp_expires,
--------------------------------------------------------------------------------

 

I am fairly new to this , but havn't had too much trouble with anything else, but where do you put this code?

 

// We are asked to show only a specific category
       $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

 

There are four occurrences of this code

I get this error on my products

 

 

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 ' p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVA' at line 1

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 60 DAY) nlp_expires,) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '22' order by pd.products_name limit 0, 20

 

[TEP STOP]

 

 

Is there anyone out there who can help me with this one, I would greatly appreciate it

 

Thanks

Collectables