join not returning all rows - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: join not returning all rows (/showthread.php?tid=23015) |
join not returning all rows - El Forum - 09-26-2009 [eluser]mike34666[/eluser] i have 3 tables involved in this query. The first is an entry table which can have 1 or more users associated with it by the entry_user table. Then I have the user table which holds the user info. The following sql command works. Code: select entry.id, user.first_name in this example the entry table is associated with 2 users. so it returns: +----+------------+ | id | first_name | +----+------------+ | 9 | David | | 9 | Jonny | +----+------------+ But when I try and use the codeigniter object oriented method it only returns 1 row, ie 1 name. here is the code i tried: Code: $this->db->select('entry.id AS entry_id, user.first_name AS first_name'); I know that I can put the straight sql command in the get command but I want to use the object oriented method if possible for clean code. can anybody tell me what I am doing wrong? thanks. join not returning all rows - El Forum - 09-27-2009 [eluser]überfuzz[/eluser] Could you display the query-string rendered by your code? join not returning all rows - El Forum - 09-27-2009 [eluser]bigtony[/eluser] In your join to entry_user, your original sql references entry_user.entry_id but your AR version references entry_user.id. join not returning all rows - El Forum - 09-27-2009 [eluser]mike34666[/eluser] thanks bigtony - that did the trick. sometimes after looking at code all night, you miss the simplest things. |