PHP Select query

Question

Hello All,

       for()
          {
            SELECT * from x union select * from y union select * from z
          }

I added union to all other queries which comes,when for loop runs but in my last line ,i've to remove the UNION ,how to do this.

Thanks in advance!

What are you trying to do? Could you try to explain a little more clearly please? — dweiss
– dweiss, Commented May 1, 2012 at 16:00

Travesty3 · Accepted Answer · 2012-05-01 16:02:55Z

1

You haven't given much information to work with, but I'm assuming you're starting with an array of query strings. If so, try this:

$queries = array();
$queries[] = "SELECT * FROM x";
$queries[] = "SELECT * FROM y";
$queries[] = "SELECT * FROM z";

$query = implode(" UNION ", $queries);

// $query now contains "SELECT * FROM x UNION SELECT * FROM y UNION SELECT * FROM z"

answered May 1, 2012 at 16:02

Travesty3

14.5k7 gold badges64 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1321210 Over a year ago

:I want to remove the union only in the ueries[n] means the last line of the total no of queries.

Travesty3 Over a year ago

It's still very unclear to me what you're trying to do. Could you edit your question and include more detail and an expected result?

Collectives™ on Stack Overflow

PHP Select query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related