Hi guy's below is my code which displays the most recent activity of users that i am subscribed to on my website... the code orders the latest activity via time. I am trying to limit to display just 10 records in total, however, the code below for some reason limits it to 10 records per person im subscribed, i.e if i am subscribed to 5 people it will display 50 record..

How can i make it display only 10 most recent items from all users, not per user?

Thanks
Jamie

Code:
<?
             


 $query = mysql_query ( "SELECT * FROM `Subscriptions` WHERE `subscriber` = '$id'");

 while ( $sched = mysql_fetch_object ( $query ) )
        {
 
$query1 = mysql_query ( "SELECT * FROM `Activity` WHERE `Username` = '$sched->subscribed' order by time desc Limit 0,10" );

 while ( $sched1 = mysql_fetch_object ( $query1 ) )
        {


 $subscribed1 = mysql_query ( "SELECT * FROM `users` WHERE `Username` = '$sched->subscribed'" );
$sub   = mysql_fetch_object ( $subscribed1);


 echo '<div class ="smallertxt"><img src ="'.$sched1->Image.'.png" height ="11" width ="11"> <b><a href ="#id='.$sub->username.'">'.$sub->name.'</a></b> <font color ="white"> '.$sched1->Activity.' </font> </b></b> ';
}

}


?>