I'm trying to output a list of different itmes grouped by the date they were stored in the database I'd need help with both MySQL (query) and PHP (output). MySQL table id | subject | time 1 | test1 | 1280278800 2 | test2 | 1280278800 3 | test3 | 1280365200 4 | test4 | 1280451600 5 | test5 | 1280451600 OUTPUT Today test5 test4 Yesterday test3 July 28 test2 test1 I'd appreciate any help on this. Thanks!