MyBB Support COUNT (SQL) problem Submitted by DarSider, 25-06-2015, 04:01 AM, Thread ID: 5026 Thread Closed Reply RE: COUNT (SQL) problem 25-06-2015, 04:26 AM #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 More 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.
RE: COUNT (SQL) problem 25-06-2015, 04:26 AM #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 More 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.