No replies to this topic

[dariodn]

Hi guy, I need to know how execute a query in IPB language.
I want show in "topic view" template a sidebar listing all users that are watching that topic.

The query could be:

$query = "SELECT m.member_id, m.members_display_name, tr.topic_id, t.title FROM ibf_tracker tr LEFT JOIN ibf_members m ON (m.member_id=tr.member_id) LEFT JOIN ibf_topics t ON (t.tid=tr.topic_id) WHERE tr.topic_id= XX ";

but I don't know how did it.
tnx