[Vince]

This is where ORDER BY comes in. I suppose you want to order by time and date in DESCending order, but your setup makes it slightly difficult. You can save an entire timestamp in one column (using either a Unix timestamp with an int column, or using a native datetime column).