merge two sets of rows

[scorpioy]

I have 2 sets of rows retrieved from 2 different tables. Is there any function in MySQL or PHP so that I can merge those 2 sets of rows and let each row mixed with another for 2 sets?

I mean the 1st row in the new set is from set 1 and the 2nd row is from set 2, and the 3nd row is from set 1, and the 4th one is from set 4, and so on. If one set has more rows than another, then simply append the rest to the end.

Thanks

[leatherback]

Well, you can add all the records to an array, and sort the array according to their keys.

[scorpioy]

The problem is I use mysql_data_seek to iterate each row in a set, and this is done long time ago, which also relates other code, so I don't want to change them. Now I want to add another set of result of rows to the existing one, so I want to find a easier way to mix them with minimum change to previous code.

Is there such a way?

Thanks