Hi Absolute, thanx for your reply :)

The code is not for a template or file within zen cart, it's a vbadvanced (portal page system through vBulletin forum) module that calls information from the database to display the latest products on an outside page, which is why I need the correct query to call the sales/specials price...if that makes sense lol