[eluser]datguru[/eluser]
Hello everyone first post here, been using code igniter for about 3 weeks now and im loving it, I wonder if any of you could help me here.
What I'm trying to accomplish is pulling data from one table collecting the ID fields and then passing all those id fields into a secon query to gather information from another database heres a little example.
Code:
foreach($this->db->result() as $row)
{
$inst_id = $row->institutionid //Need this to be put into an array
}
That gathers the ID I need now im stuck on the next bit what i want to do is access the project table and get the project name based on the ID.
The only way I can think of doing this is doing a query for each element in the array and putting that into another array of names. I need any names with any of those values in the ID field.
Any help would be greatly appreciated.
Thanks guys.