[jake8804]

My knowledge of Smarty a few hours ago was zero and it has risen very little so far. You're right about that query not making sense...I should get some sleep haha.

There is a customers.company and products.provider but no way to join the tables. I can't see any table that connects provider to customers.id or customers.company. Maybe I'm too tired...I'll try again tomorrow.