displaying a single row in view

The documentation is excellent on this topic.

http://www.codeigniter.com/user_guide/da...sults.html

The error is telling you that you do not have an appropriately formatted array for the foreach to loop through. You need to test result sets if there is any chance that you may not get any results from the search.

You could start by echoing your array with print_r and see what results you are actually outputting.

Best wishes,

Paul.