I am making some progress on understanding this system of web design
. I COULD run an SQL query directly from the template right now and get the info that way but that is undesirable, yes?
The query will be something like:
SELECT customers.company
FROM customers
JOIN products
ON customers.provider = products.provider;
And then the Smarty assign is:
$smarty->assign('company',$product);
How do I put them together?
Also, I have been trying to figure out which .php file to use to assign variables to $product...which one is it? I am more of a database guy than a web designer lol