Instead of storing NA for the usernames the second time around, store the actual user name so the second record will look like:
2 - user2 - user1 - 1/4/2010 - 6
then change the order by clause to:
ORDER BY `date` ASC
so the second record will be the first one returned.