- #1
Stephanus
- 1,316
- 104
Dear PF Forum,
Happy New Year.
This forum is very, very useful, helpful and elegant. Heavily moderated.
I find this thread: https://www.physicsforums.com/threads/give-credit-to-the-mentors.848493/ [Broken]
As many of you might know.
I just realize that to thank every mentors that alread answer our questions is very difficult.
Perhaps if it's not against the rule, we can query PF Forum.
For example:
Which threads that I, as a starter, have a particular mentor (or advisor or insight author) has replied.
Perhaps I can't express myself clearly. But this what I might have done.
Supposed: ThreadTable is the thread table
and PostTable is the posting inside the ThreadTable, PostTable is many to one relationship with ThreadTable.
Supposed I want to find how many threads that Janus have replied to my thread.
I know that this is highly illegal for any member to do such query like this in SQL and accessing PF server.
It's just that I just remember something with my thread.
https://www.physicsforums.com/threads/hydrogen-ion-antioxidant.850337/
I remember "ByStander" name. He/She has many times replied my thread. And I forgot to thank him/her in Give Credit to Mentors.
Not that I want every member can query PF server, perhaps if there is a dialog box for us to display just our own thread that has particular member who posted in it.
Happy New Year.
This forum is very, very useful, helpful and elegant. Heavily moderated.
I find this thread: https://www.physicsforums.com/threads/give-credit-to-the-mentors.848493/ [Broken]
As many of you might know.
I just realize that to thank every mentors that alread answer our questions is very difficult.
Perhaps if it's not against the rule, we can query PF Forum.
For example:
Which threads that I, as a starter, have a particular mentor (or advisor or insight author) has replied.
Perhaps I can't express myself clearly. But this what I might have done.
Supposed: ThreadTable is the thread table
and PostTable is the posting inside the ThreadTable, PostTable is many to one relationship with ThreadTable.
Supposed I want to find how many threads that Janus have replied to my thread.
Code:
select ThreadTable.ThreadTitle
from ThreadTable
inner join PostTable on PostTable.ThreadId = ThreadTable.ThreadId
where (ThreadTable.Starter = MyUserName) and (PostTable.MemberName = "Janus")
group by ThreadTable.ThreadTitle
I know that this is highly illegal for any member to do such query like this in SQL and accessing PF server.
It's just that I just remember something with my thread.
https://www.physicsforums.com/threads/hydrogen-ion-antioxidant.850337/
I remember "ByStander" name. He/She has many times replied my thread. And I forgot to thank him/her in Give Credit to Mentors.
Not that I want every member can query PF server, perhaps if there is a dialog box for us to display just our own thread that has particular member who posted in it.
Last edited by a moderator: