Quote:
Originally Posted by Ted S
Thanks sockwater however I don't need the IDs of the posts in the thread but rather of each post from each user who has posted. There is a pretty simple query for this but it involves restructing the vote data which is why I am holding off on it until a bigger update.
But I am very amped about adding this... think it will be a great data point for people's postbit block.
|
I'm not quite following you. Post #1054 shows how, with one query, you can pull all the information (what the vote was, the voter's username & userid) on each vote for each post being displayed in the thread, and puts it in an array that's indexed by postid. You can use that array to display all a given post's votes, showing what the vote was and linking the voter's username to their profile below the postbit when that post author is viewing the thread. I was only showing you how it can be done with one query per thread instead of one query for each post in the thread. No restructuring of the vote data needed. Hopefully I've explained this well.