MDK
Member
Sooo new I need a pro to help me here ![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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'
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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'