MyBB Support

COUNT (SQL) problem

Submitted by DarSider, 25-06-2015, 04:01 AM, Thread ID: 5026

Thread Closed

25-06-2015, 04:01 AM

Hello all
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

- Web Developer & Designer

Website : https://developement.design/
Skype : ef.team
Email : [email protected]

Users browsing this thread: 4 Guest(s)