Display single record in view

[eluser]simplepixie[/eluser]
All tutorials etc that I have read all cover how to get records from a database and use the foreach to display the results (i.e. list or table etc) and are mainly based around blogs, but I can't seem to find any examples of how to grab and display just one record.

What I am trying to do is view the details of an an account holder/user but I can't work out how to pass the result information back to the controller and view file to display this information (I know how to get it, I hope).

Just to expand, I have a list of accounts and I want to click on a link to view the account's full details and then if necessary update them etc.

Can someone please enlighten me.