I have a site which has 20 products
On my home page I want to display the pagetitle, tv.image, introtext from a ‘featured product’.
So in my homepage template I want a singleselect TV which pulls in all the resources and then once selected and saved, the above fields for that resource are displayed on the home page.
When I started it felt like an easy one, but I can’t think how to put it together!
I have a TV in my homepage template which calls the product resources:
@SELECT `pagetitle`,`id` FROM `[[+PREFIX]]site_content` WHERE `parent` = 22 AND `published`= 1 ==`id`
I can print this TV in my template, and it gives me the resource ID, but not sure what Snippet to use to pull in the info I need form that ID?
One other slight issue is that using the above code, it doesn’t pull in any nested resources to my select box?