MyBB Support

COUNT (SQL) problem

Submitted by DarSider, , Thread ID: 5026

Thread Closed

RE: COUNT (SQL) problem

#2
Code:
SELECT COUNT(t.tid) FROM mybb_threads t
LEFT JOIN mybb_posts as p ON( t.uid = p.uid )
WHERE t.uid = '1'
GROUP BY t.tid
Do not let your difficulties fill you with anxiety, after all it is only in the darkest nights that stars shine more brightly. - Ali(a.s)

Developer( PHP, Python, C++, HTML+CSS, JS I am available for Hire. Message Me for details.


Users browsing this thread: 2 Guest(s)