Is there a way to write combine or mysql statement with codeigniter ivr

Asked Nov 11 '14 at 06:09

Active Nov 11 '14 at 06:13

Viewed 48 times

Is there any way to write ivr for the following statement with codeigniter

SELECT customer_id, last_name, first_name
FROM customers
WHERE (last_name = 'Johnson' 
OR (last_name = 'Anderson' AND state = 'California') 
OR (last_name = 'Smith' AND status = 'Active' AND state = 'Florida');

Coule someone please help me on it ?

edited Nov 11 '14 at 06:13

Lorenz Meyer

19,166
22
75
121

asked Nov 11 '14 at 06:09

Swarna Sekhar Dhar

1

possible only in **codeigniter dev 3.0** in older version use where part as string http://stackoverflow.com/questions/26624535/codeigniter-active-record-group-or-statements?answertab=votes#tab-top – Girish Nov 11 '14 at 06:15
$this->db->query('YOUR QUERY HERE'); is not work? im rare using query builder, main using AR class. – Hendra Nucleo Nov 11 '14 at 06:23

Is there a way to write combine or mysql statement with codeigniter ivr

0 Answers0