SOLVED::I WANT TO DISPLAY THE COURSE NAME

[eluser]charlesmudy[/eluser]
Hi,

I'm new to CodeIgniter.

My question is, I would like to view the name of my course_id which is in another table but it simply gives me the details from that table.

I have a table called student which has the ID of the courses table, so when I select the row from the student table..it gives me ofcourse the row id but I want the course name to be displayed.

My code:

&lt;?php echo "Status: " . " " . $row->status_id; ?&gt;<br />
&lt;?php echo "Course: " . " " . $row->course_id; ?&gt;<br />
&lt;?php echo "Nationality: " . " " . $row->nationality_id; ?&gt;

My display:Attached


Thanks in advance.

Charles