Dates and timestamps

[MrBelfry]

Hi i'm developing a very simple guestbook application using php and mysql. I need someway of recording the date that somebody adds a message and them I need to be able to order returned records by this date.

I've tried using a timestamp field but mysql throws a wobbler when I try to order my records using this field. What is the best way for recording times and dates so that I can order records using that field?

Thanks for any hints and tips

MrBelfry

 

[MrBelfry]

Ooops

Next time I'll triple check my sql statement before I'll post a question here.

Sorry for wasting your time

MrBelfry