StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to not select an id that is listed in another table from an adjoining table in SQL?
text
Body
copied!<p>A little more background on my issue. I have a "Followers" sidebar on my site where users can follow other users. The problem is that currently the users that appear in this sidebar can also include users they already follow. I would like to modify the function so this no longer happens. Here is the model function that I currently use...</p> <pre><code>public function get_oldest($limit = 10, $user_id) { $this->db ->select($this->db->dbprefix('profiles').'.*, g.description as group_name, users.*') ->join('groups g', 'g.id = users.group_id') ->join('profiles', 'profiles.user_id = users.id', 'left') ->group_by('users.id'); $this->db->order_by('users.created_on', 'ASC'); $this->db->limit($limit); $results = $this->db->get('users')->result_array(); return $results; } </code></pre> <p>Here is the controller function...</p> <pre><code>function get_oldest() { $this->load->model('user_account/user_account_m'); $limit = $this->attribute('limit'); $user_id = $this->current_user->id; $users = $this->user_account_m->get_oldest($limit, $user_id); return $users; } </code></pre> <p>The "Follower"(default_follow) table in the sql database has the following structure...</p> <blockquote> <p><strong>id</strong> = the id of the follow event<br> <strong>follower_id</strong> = the user_id of the person who is doing the following<br> <strong>followed_id</strong> = the user_id of the person being followed</p> </blockquote> <p>The "Profile"(default_profiles) table in the sql database has the following structure...</p> <pre><code>user_id display_name first_name last_name </code></pre> <p>I know I need to use the current user's id in some way to get this to work, I'm just having a hard time figuring out how. Thanks in advance for your help people.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload