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

SQL result in template?

Discussion in 'General PHP and MySQL Discussions' started by MDK, Apr 26, 2016.

  1. MDK

    MDK Member

    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 ?

    FROM xf_post AS post
    LEFT JOIN xf_thread AS thread ON (thread.thread_id=post.thread_id)
    WHERE thread.node_id != '23'
  2. wang

    wang Well-Known Member

    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.

Share This Page