I have a small problem
I'm trying to do this query on phpmyadmin, to get member posts count where the member is the thread starter (the number of messages on my own threads)
Code:
SELECT COUNT(*) FROM mybb_threads as t, mybb_posts as p WHERE t.uid = p.uid AND t.uid = 1
And tried this :
Code:
SELECT COUNT(*) FROM mybb_threads as t, mybb_posts as p WHERE p.username = 'AmazOuz' AND t.username = 'DarSider'
But i get biiiig numbers (119639...etc)
I don't know where is the problem :noh:
Please help
Thanks