Get forum of Reply from database
I want the latest posts (topics or replies) from a specific forum. I can get the latest posts from all forums with something like:
SELECT * FROM wp_posts WHERE post_type = ‘reply’ OR post_type = ‘topic’ ORDER BY post_date DESC LIMIT 4
What I need to do is to specify the forum of the topic or reply by adding a condition saying something like:
If it is a reply get the parent of the parent_type (i.e. the specific forum which is the parent of the topic) and if it is a topic get the parent_type (which I can get from the wp_posts table). Then check if this matches the specific forum we want.
No idea how to do this though (especially the parent of the parent_type bit)……..
You must be logged in to reply to this topic.