[totaltec]

You are right, no queries from the template. Definitely a bad practice.

But that doesn't look like the right way to assign to smarty. What you have there looks like it will assign whatever value $product has to a new smarty variable called company.

It is not going to assign anything to the product array like that.

I have to admit that I am also confused by your query. Join on customers.provider. There is no such column name that I am aware of.

Bear in mind that I have much less experience with x-cart pro than I do with gold. That may be my confusion.

-Mike