[eluser]Unknown[/eluser]
Hello fellow CI'ers!
The query I'm trying to build deals with two tables: leaders and followers. I need to organize my DB query in a specific way so that I can properly display in my view in the following example format:
Leader
Follower
Follower
Follower
Leader
Follower
Follower
Follower
My code is a hack job and I'm wondering if there is a better way. Especially one where there is no presentation code in the controller.
Code:
$query = $this->db->get('leader');
foreach ($query->result() as $row)
{
// get leader name
$data['party'][] = '<div id="leader">'.$row->am_firstName." ".$row->am_lastName.'</div>';
// get all the golfers under this leader
$queryFollowers = $this->db->get_where('follower', array('leader_id' => $row->id));
foreach ($queryFollowers->result() as $rowFollowers)
{
$data['party'][] = '<div id="followers">';
$data['party'][] = $rowFollowers->am_firstName." ".$rowFollowers->am_lastName;
$data['party'][] = '</div>';
}
}