2 MySQL queries - Merge results - using PHP

[Phill Pafford]

Hi all,

I am using PHP to query a MySQL DB, this part is working fine for me. The problem is I have two queries which return the values in CSV (Comma Separated Value) format. I trim off the last comma so my return looks like this:

First Query

value1, value2, value3, value4, etc...

Second Query

value1, value2, value3, value4, etc...

Now my question is:

How do I get the two queries to merge every other value?

example:

Merge Results

value1, value1, value2, value2, etc...

[Phill Pafford]

Still need help