Join, if? - 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, if? (/showthread.php?tid=14883) |
Join, if? - El Forum - 01-19-2009 [eluser]Robert May[/eluser] Just a quick question: is it possible to use the join command on a query based on whether an entry actually exists? Here's the query: Code: function list_entries($number, $offset) The one that is causing trouble is the translations bit. I want it to only join if the translation actually exists, rather than creating an error. The only other way I can see to do it is to create blank records for every news article, though I'm probably wrong. Any ideas? Join, if? - El Forum - 01-19-2009 [eluser]Phil Sturgeon[/eluser] Would a right join not do the trick? Code: $this->db->join('translations', 'trans_ref_id = news_id', 'right'); That means if you have a news_id, but there is no matching trans_ref_id, it will load NULL for all the fields in translations. Join, if? - El Forum - 01-19-2009 [eluser]Robert May[/eluser] That worked. Thanks very much for the help, it's hugely appreciated! |