+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Query Conversion (/showthread.php?tid=29777)
Query Conversion - El Forum - 04-20-2010
[eluser]Suhas nazir[/eluser]
Can anyone please convert this query to codeigniter format
select * from tablename where id="1" or id="2";
Query Conversion - El Forum - 04-20-2010
[eluser]RobertB.[/eluser]
Try this,
$this->db->where('id', 1);
$this->db->or_where('id', 2);
$query = $this->db->get('tablename');
return $query->row();
Query Conversion - El Forum - 04-20-2010
[eluser]Suhas nazir[/eluser]
Thanks