[Pilbeam]

I'm not sure if this has been answered before, I've been searching the forums and have seen many similar queries, but not any that suit my specific question;

I need to retrieve the wholesale price(s) of each product as they are looped through on the product list, the product ID is defined in a Smarty variable on the products_list.tpl, but I need it as a PHP variable so that I can query the database BEFORE the tpl loads.

Can someone help?