[pipercub]

funkydunk,

Thanks for the code and information. It didn't work, but I appreciate the reply just the same!

Here's my thought...

products_t.tpl is already pulling price data for each product from the database. It pulls the price from the "xcart_pricing" table based on the product id. How can I define not only the product id, but the quantity column as well? I guess I should have explained that I only have 3 levels of pricing (which eliminates the need to have a script find the lowest price), so the price that is associated with the product id + a quantity of 3 is always what I need.

In other words

{include file="currency.tpl" value=$products[product].price}

seems like it's on the right path, but I just need to refine it to recognize (and pull from the database) a price for quantity of 3.

I guess what I need to know (being a mySQL novice) is how do I pull data from a specific space? (in this case it's xcart_pricing+product id+quantity of 3)

Thanks again,
Piper