$result = dbquery(

	"SELECT f.*, COUNT(t.thread_id) AS thread_count, MAX(t.thread_lastpost) AS last_post, f2.forum_name AS forum_cat_name, u.user_id, 

 

u.user_name FROM ".$db_prefix."forums f

	LEFT JOIN ".$db_prefix."threads t USING(forum_id)

	LEFT JOIN ".$db_prefix."forums f2 ON f.forum_cat = f2.forum_id

	LEFT JOIN ".$db_prefix."users u ON f.forum_lastuser = u.user_id

	WHERE ".groupaccess('f.forum_access')." AND f.forum_cat!='0' GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC"

);

// Establish <span style="border-bottom: 1px dotted black;">mySQL</span> database connection

$link = dbconnect($db_host, $db_user, $db_pass, $db_name);

 

function dbquery($query) {

	$result = @mysql_query($query);

	if (!$result) {

		echo mysql_error();

		return false;

	} else {

		return $result;

	}

}