• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

SQL result in template?

#1
Sooo new I need a pro to help me here :)

I have this SQL query where the results should be used in a template for some forum stats I want to display.
How do I get a variable which I can use in that particular template ?
Thanks

Query:
SELECT COUNT(*)
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id=post.thread_id)
WHERE thread.node_id != '23'
 

wang

Well-known member
#2
This would require a custom add on. Basically you will have to add the query in the model file, then in the controller file you can call it and then register the variable so you can use it in the template.