Get rows from table where using array - help - 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: Get rows from table where using array - help (/showthread.php?tid=13797) |
Get rows from table where using array - help - El Forum - 12-05-2008 [eluser]mikka23[/eluser] Its quite simple but I dont know how to do it. I have a lookup_skills table and a skills table. I need to get every row from the skills table for each skill_id(from skills_lookup table) is equal to id(id in skill table). This is what I have but it just returns the row for the last skill_id retrieved. Code: $this->db->where('uid', $this->uri->segment(3)); Help appreciated. Get rows from table where using array - help - El Forum - 12-06-2008 [eluser]mikka23[/eluser] Managed to accomplish the desired result although it doesnt seems like the easiest way: Code: $urlid = $this->uri->segment(3); |