Dynamic Email Content and MySQLi Server Behaviours
I am trying to send emails with dynamically generated content.
So far, using the 'Blank' template, I have managed to send an email with dynamic content, but it includes ALL the content of my d/b table, with column names as the headings in the email. This not what I want.
Instead, I have a recordset that joins several tables and requires a URL parameter to filter the data required (eg: id_prf=2 etc).
How do I then include this in the email template?
I have seen an old forum post (http://www.webassist.com/forums/posts.php?id=33942) that says to add globals for the recordset in the template page. However there is only a snippet of code and I can't get it to work.
What would be really helpful is the complete code for an example page that sends the email and an example template file with the globals included.
Hope this is clear.