JOIN QUERY

[eluser]CroNiX[/eluser]
Try the tutorial, which shows you how to display db results in a view. You can also google "mysql join tutorial" for many existing tutorials to teach you how to use JOIN.

http://ellislab.com/codeigniter/user-gui...index.html