mysql - order in order

[chings]

hello i have a table to store member's message

and i would like to select the latest message by each member and list them out

i use the following query

SELECT * FROM message WHERE user_id >'0' GROUP BY user_id ORDER BY time DESC LIMIT 0,10

but i found that it doesn't show what i expect. i think it show the lastest 10 ppl of their corresponding message.

but finally it comes out , the lastest 10 ppl of their earliest message

could anyone point out what's wrong with my query

[Lars_Berg]

select * 
  from message m
 where user_id > 0
   and time in 
      (select max(time)
         from message
        where message.userid = m.userid)