Newest 5 Items

[Guest]

Does oscommerce have a api where i could get the newest 5 articles to use them in an other application?

Or have i to do this "manual" (connect to db, make an select, etc...)

 

thx

[Guest]

ok i got it with

select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
   if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . SHOPDB . ".products
   p left join " . SHOPDB .".specials s on p.products_id = s.products_id,
   " . SHOPDB .".products_description pd
   where p.products_status = '1'
   and p.products_id = pd.products_id
   and pd.language_id = '2'
   order by p.products_date_added desc limit " . $counterNewProducts;