Multiple Database Queries

[eluser]joshvermaire[/eluser]
Jaketoolson, thanks for getting back to me on this.

The problem is that in the second query,

Code:

$row['app_id']

gives me an error. If I did

Code:

$row[0]['app_id']

it would return a value, but then that only lets me query for one app_id where I want to query for all of them.

Maybe a join is better, like you said. Could you help me with the code?

Would I add the following to the first query?

Code:

$this->db->join('applications', 'applications.id = using.app_id');

Can I use method chaining to just select app_name from the join?

Thanks.