multiple query and foreach loop

[eluser]CroNiX[/eluser]

Code:

$data = $this->db
  ->select('client.name, projects.description')
  ->join('projects', 'client.id = projects.client_id')
  //->where(where conditions, if needed)
  ->order_by('client.name')
  ->get('client')
  ->result_array();

View:

Code:

$last_client = null;

foreach($data as $d)
{
  //only list the client name once (category in your case)
  if ($last_client != $d['name'])
  {
    $last_client = $d['name'];
    echo $d['name'] . '<hr>';
  }
  //now list all of their project descriptions (linkurl in your case)
  echo $d['description'] . '<br>';
}