Posted: 25-06-2015, 04:15 AM
(This post was last modified: 25-06-2015, 04:24 AM by DarSider.)
Tried it in PHPMyAdmin
It returns :
My Threads TID, each TID has his own POSTNUM which is the number of posts in that thread
And not all my threads are shown, only some of them http://prntscr.com/7l0jdh
EDIT : I added AND p.uid = 1 in the WHERE condition
I get each TID with my posts number in that thread.
I just have now to delete the group by, and i get the postnum
I just have to do this to get what i need :
SELECT COUNT(p.pid) FROM mybb_posts p LEFT JOIN mybb_threads t ON( t.tid = p.tid ) WHERE t.uid = '1' AND p.uid = '1'