Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- I have 3 tables. Users, Topics and Quotes. Here is my tables and columns:
- users
- ------
- user_id
- email
- username
- topics
- ------
- topic_id
- topic_name
- quotes
- ------
- quote_id
- quote_name
- mix_table
- ---------
- user_id
- topic_id
- quote_id
- $this->db->from('users');
- $this->db->join('quotes', 'quotes.quote_id = mix_table.quote_id');
- $this->db->join('topics', 'topics.topic_id = mix_table.topic_id');
Add Comment
Please, Sign In to add comment