Error code 1054: Can't figure out why I'm getting this

[eluser]dallen33[/eluser]
Here is my code:

Code:

<?php
    $clients_query = $this->mobile_db->get_where('clients', array('rep_id' => $this->dx_auth->get_user_id()));
    
    if ($clients_query->num_rows() > 0):

    foreach($clients_query->result() as $clients_row):
?>

And here's the error:

A Database Error Occurred
Error Number: 1054
Unknown column 'rep_id' in 'where clause'
SELECT * FROM (`clients`) WHERE `rep_id` = '3'

I don't understand what's so wrong about the database code. what am I missing?

[eluser]jalalski[/eluser]
it's telling you that there is no column called 'rep_id' in the table 'clients'. Double check that there is such a column...

[eluser]dallen33[/eluser]
There definitely is a column called rep_id in clients. Triple checked.

[eluser]dallen33[/eluser]
I figured out the problem, but can't figure out a solution.

I have two databases I'm working with, and both have a clients table. One doesn't have a rep_id, one does. In my controller, I put this under the parent::Controller();

Code:

$this->mobile_db = $this->load->database('mobile_booking', TRUE);

And this is the code in my view:

Code:

<?php
    $clients_query = $this->mobile_db->get_where('client', array('rep_id' => $this->dx_auth->get_user_id()));
    
    if ($clients_query->num_rows() > 0):

    foreach($clients_query->result() as $clients_row):
?>

Is my database load in the wrong spot?