merge of 4 sql results and sort

Hi,
I have got 4 results out of 4 different sql queries
$row1 = mysql_fetch_array($result1);
...
$row4 = mysql_fetch_array($result4);

all arrays have got the same keys.

I want to merge those 4 results to one $row, using one key (author_sort) to sort the rows alphabethically.

How can I manage it and if yes, is it possible also with php3???

Thank you for help

Gabi

wow php3... do people still use that?

anyway, the 'smartest' way of merging and sorting is to let the database do it through a UNION clause (rtm for more details)

Otherwise you'll have to append the arrays to eachother and bubble-sort it (unless php3 already had array-sort functions, again, rtm for more)

People still use it, at least the company for which I have to do this job.

As far as I know, UNION would do all I need, but it requires mySQL 4.0.0 and I have got 3.23
Is there any solution for older versions???

Gabi