Loading MySQL rows starting from a timestamp
Posted: Wed Oct 12, 2005 10:07 pm
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.
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.