I would like to create HTML table with my query results. The HTML table should look like this:

I don't really understand about Codeigniter's HTML Table Class, so I just create a loop for each column of the table on my view like this:

 username; ?> 
 useraddress; ?> 
 userage; ?> 
 usersex; ?> 

Turns out it was a very bad decision. It makes my table look horizontally instead vertically like it used to.

Here's my model:

db2 = $CI->load->database('db2', TRUE);
        }


        function namelist()
        {
            $query = $this->db->query("SELECT name as uername FROM table1 ORDER BY name");
            return $query->result();
        }

        function addresslist()
        {
            $query = $this->db->query("SELECT address as useraddress FROM table1 INNER JOIN name
                                       ON address.id = name.id GROUP BY id ORDER BY name");
            return $query->result();
        }

        function agelist()
        {
            $query = $this->db->query("SELECT age as userage FROM table1 INNER JOIN name
                                       ON age.id = name.id GROUP BY id ORDER BY name");
            return $query->result();
        }

        function sexlist()
        {
            $query = $this->db->query("SELECT sex as usersex FROM table1 INNER JOIN name
                                       ON sex.id = name.id GROUP BY id ORDER BY name");
            return $query->result();
        }

}

And then here's my function on my CONTROLLER:

public function index()
    {

        $data['nameloop'] = $this->front_model->namelist();
        $data['addressloop'] = $this->front_model->addresslist();
        $data['ageloop'] = $this->front_model->agelist();
        $data['sexloop'] = $this->front_model->sexlist();


        $this->load->view('home',$data);
    }

This make me quite confused. Whether it's the HTML tag or I code it wrong.. I don't know... Thank you for your help, guys...