tricky multi-table data sort

[Anon]

Okay, so new question: I've got the following stuff pulling off of different database tables:

$res = mysql_query(" SELECT UNIX_TIMESTAMP(date_entered) AS date_entered,entry_title FROM entries ORDER BY UNIX_TIMESTAMP(date_entered) LIMIT 5");

$subres = mysql_query(" SELECT UNIX_TIMESTAMP(date_entered) AS date_entered,subentry_title FROM subentries ORDER BY UNIX_TIMESTAMP(date_entered) LIMIT 5");

effectively, I want to generate a list of the 5 NEWEST items (by date), regardless of which table they came from...

so, $res will get me 5 items from 'entries' sorted from newest to oldest. $subres will similarly get me 5 items from 'subentries' sorted from newest to oldest.

how, then, would I sort these two lists against each other in some meaningful way so that I could then print out the 'entry_title' OR 'subentry_title' for each of the 5 newest entries/subentries?

[Anon]

Hi Raz,

Step1: Save the data you got from the first query in an array
while($row=mysql_fetch_array($res))
{
$dt=$row["date_entered"];
$title=$row["entry_title"];
$data_arr[$dt]=$title;
}
Step2: Get the data from the second result and add that data also to the same array
while($subrow=mysql_fetch_array($subres))
{
$dt=$subrow["date_entered"];
$title=$subrow["subentry_title"];
$data_arr[$dt]=$title;
}

Now sort this array to get the first five values ( recent dates )
krsort($data_arr);
$i=0;
while( list($key, $val) = each($data_arr))
{
$i++;
if($i<=5){
echo "Date:$key Title:$val<br>";
}
}

This should work for you

Cheers
Ajay