Announcement

Collapse
No announcement yet.

How to Query to list all usernames in a vB5 thread ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • emral
    replied
    Thank you very much, that was what I was looking for.






    Leave a comment:


  • Wayne Luke
    replied
    You can try something like: SELECT * FROM node WHERE parentid=XXXXX

    XXXXX would be the nodeid of the topic. However if you allow comments, you'll miss those. A problem with hierarchal node systems is that you don't actually know what needs to be retrieved until you traverse the entire ancestry tree (this is the closure table btw). Hard to do in a single query.

    Leave a comment:


  • emral
    started a topic How to Query to list all usernames in a vB5 thread ?

    How to Query to list all usernames in a vB5 thread ?

    Hi I have thread with 140 pages and I want to list all usernames who have posted on this thread, because writing down all names one by one takes too much time.

    Pls Help.
    Last edited by emral; Tue 30 Jun '20, 8:53am.

Related Topics

Collapse

Working...
X