select ID,Name_of_Movie as Name_of_Moviee
from moviestable
UNION
select ID,New_Name
from moviestable
I need this query in codeigniter..
Asked
Active
Viewed 4,193 times
0
Alok Patel
- 7,842
- 5
- 31
- 47
sai vamshi
- 25
- 1
- 5
-
tried the same but no use.. – sai vamshi Oct 07 '16 at 12:01
-
show your code. – Dave Oct 07 '16 at 12:02
-
you missing } of if. – Dave Oct 07 '16 at 12:05
-
no it was there..might be not copied it – sai vamshi Oct 07 '16 at 12:06
-
please try this http://stackoverflow.com/questions/2040655/union-query-with-codeigniters-active-record-pattern – kuldeep Oct 07 '16 at 12:07
1 Answers
2
there are two way for UNION first in below
$data['values']=$this->db->query(
'select ID,Name_of_Movie as Name_of_Moviee from moviestable
UNION
select ID,New_Name from moviestable')->get()->result_array();
Second way to UNION in
$this->db->select("ID,Name_of_Movie as Name_of_Moviee");
$this->db->from("moviestable");
$query1 = $this->db->get_compiled_select(); // It resets the query just like a get()
$this->db->select("ID,New_Name");
$this->db->distinct();
$this->db->from("moviestable");
$query2 = $this->db->get_compiled_select();
$data['values'] = $this->db->query($query1." UNION ".$query2)->result();
You are implement any one for your query
kuldeep
- 218
- 1
- 10
-
Dear Your answer like a comment. please explain it and correct the syntax.. Its very important for stackoverflow guys. – Kumar Rakesh Oct 07 '16 at 12:20