Sort and separate days with unix time()

[ajna]

I have a databse of articles, each article having a record field TimeCreated which contains the unix timestamp when the record was created -- a simple insertion of the current system time() to the db.

I am trying to list articles by the days they were created. So my first screen would only display those articles created today, clicking "PREVIOUS" would then bring the user to a list of articles created the day before (or the most recent day before), etc, etc with NEXT and PREVIOUS.

Is this possible with the unix timestamp?

I was previously using the field as a timestamp(14) -- but found the system was automatically changing this date setting whenever the record in question was edited. So if I created a record on 9/12/04, then edited it on 9/15/04 -- the field would change to 9/15/04 automatically when the record's new information was written to the db.

Any help is greatly appreciated.

K

[bretticus]

Even though you could keep in mind that a unix timestamp is merely the number of seconds elapsed from jan 1, 1970 and come up with a query that subtracts 86400 (one day) from the query for each day (could be messy though), I highly recommend changing your timestamps to MySQL timestamps (assuming you are using MySQL here of course.) That way you will be able to use the MySQL date functions and you can query the real unix timestamp with the UNIX_TIMESTAMP(colname) in your query to work with the timestamp in PHP.