mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '6363' order by postid; +--------+----------+-------------+--------+---------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+-------------+--------+---------------------------+-------------------------+ | 75832 | 0 | EricBackus | 1487 | Rules Question about Seki | 2008-05-25 14:20:07 | | 75837 | 75832 | erislover | 372 | | 2008-05-25 15:24:56 | | 75847 | 75832 | Sverre | 171 | | 2008-05-25 16:41:43 | | 75868 | 75847 | Bill Spight | 2111 | | 2008-05-25 20:58:06 | | 75869 | 75868 | Sverre | 171 | | 2008-05-25 21:09:44 | | 75878 | 75869 | Bill Spight | 2111 | | 2008-05-25 21:54:46 | | 75879 | 75847 | EricBackus | 1487 | Thanks! | 2008-05-25 22:21:15 | | 75880 | 75879 | sol.ch | 129 | | 2008-05-25 22:24:05 | | 75884 | 75879 | Bill Spight | 2111 | | 2008-05-25 23:49:44 | +--------+----------+-------------+--------+---------------------------+-------------------------+ 9 rows in set (0.03 sec)