Help with join query

I'm going to guess that you have an 'id' field in both tables. The ambiguous error means that you've used a column name that appears in more than one table and it doesn't know where to look, so make sure to call out the table with the ambiguous column and you'll be fine.

Code:

$this->db->order_by('projects.id', 'desc');

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials