counting for a reply

[eluser]jhayghost[/eluser]

Code:

function furomcontent(){
    $sql = "SELECT a.fname, a.lname, topic_id, topic, views, lpost, (select count(topic2.acc_id) from forum_topic as topic2 where topic2.acc_id = forum_topic.acc_id) as countreply
        FROM account a JOIN forum_topic ON a.acc_id = forum_topic.acc_id
        ORDER BY topic_id DESC";
    $query = $this->db->query($sql);
    return $query->result();
                  
}