Query to Array?

[PHPRookie]

I am running five queries

$result1 = mysql_query($sql1)
$result2 = mysql_query($sql2)
$result3 = mysql_query($sql3)
$result4 = mysql_query($sql4)
$result5 = mysql_query($sql5)

and need to dump the results of each into the same array and sort it at the end. How do I do this?

[LordShryku]

$array = array(); // blank array
// for each of your results, do this
while($row=mysql_fetch_array($result#)) {
   $array[] = $row['field']; // put the field in the array
}

//once done, sort
sort($array);

[PHPRookie]

Thanks LordShryku. I will try this immediately.