Page 1 of 1

Loading MySQL rows starting from a timestamp

Posted: Wed Oct 12, 2005 10:07 pm
by Trenchant
I'm making a Flash support interface that is backened by php. Inside the support system support staff can chat with eachother.

The problem is I need to select ALL posts that have been made in the shoutbox since the support representative has logged in.

Here is what my timestamp looks like:
20050601184812
(year-4)(month-2)(day-2)(hour-2)(minute-2)(second-2)

I need a mysql query that will select all posts AFTER a given timestamp. Any ideas on how I could do this?

At first I thought something like pagination and searched that up but using a similar technique wouldn't work.

Posted: Wed Oct 12, 2005 10:17 pm
by feyd

Code: Select all

SELECT * FROM `table` WHERE `time` >= '20050601184812'

Posted: Wed Oct 12, 2005 10:29 pm
by Trenchant
Thanks so much for the quick reply.