running a query in a custom prestashop page
Has anyone ever managed to do this, create a custom page (not through the admin function to create a page) and have this page run a query to a database to extract data? I've looked through google and can't find any suggestion as how to do this so thought I would ask here. Prestashop uses the 'Smarty' template engine, which to be honest I have no idea on how to use. I have managed to add a new page and the template for the page in the theme (thanks to some nice person who shared their work for all to use).
It works great for a static page but I need to have it dynamic. I've looked through other template files which use a query but I can't see how it's done. Does anyone have an idea or a link to how to do this?