This should be a very easy task for OsCommerce pro.
I am looking to pull the data from certain category only
[url removed, login to view]
I want to pull the newest product within the USB section
Here's the line in modules that I think need to add the right info.
$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if([url removed, login to view], s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);