function linkToClients($value,$row){
return "<a href='".site_url('>id)."'>clients</a>";
}
'.$row - >id)."'
This link invokes directly my client site. So the question was "it's possible with set_model or other solutions, to take the ID fromt the link and start a own query with this value ($row->id).
SQL Code like this
Code:
SELECT * FROM client, client_frontuser
where client.id = client_frontuser.client_id
and client_frontuser.frontuser_id = $ID
Now I found a solution.
Instead of taking one step (frontuser -> client). I take two with one step in the middle (frontuser->frontuser_client->client). So it works.
Now, I'm interested if there is a better solution.