I have a query
"select * from test";
I have to add UNION after test
"select * from test union"
It is not concat.
How do I add union to the query?
update
select * from x where id = "2" union select * from y where id = "2" union select * from z where id = "2"
select * from x where id = "3" union select * from y where id = "3" union select * from z where id = "3"
See select statement id = 3 ,union is missing. Now,i've to add this union in the query to execute and remove last extra union and pass the query to mysql_query() function.