X-Cart forums

[PrairielandGolfCars]

(Not sure if this is a template question or MySQL question, so mods, please move to where this best fits.)

I have the Brand Year Model modification and I want to add the additonal fields $start_year and $end_year fields from the xcart_products table to the product display in product.tpl and product_t.tpl.

It's not working by just calling $start_date....or $product.start_year so I'm guessting those fields are not available to smarty because they're not included in the query that's built prior to display of the page at product.php?

Can anyone point me to the place where I need to add those two fields so I can call them in the smarty template?

Thank you!

[balinor]

It actually has to do with a Third Party Mod, so I'm moving it to that forum

[PrairielandGolfCars]

I understand, but there's not much hope of the author answering the question here , and, it's just a question about adding an "extra field" (no matter where it came from or how it got there) from the table to the query so it's available.

Maybe I could rephrase my question as, "How do I get xcart_product "add_date" into the query so I can pull it into the product display?"