JChilds Posted July 1, 2008 Share Posted July 1, 2008 I have a table with three columns: Timestamp, ID, Amount Every hour, new data is written to the table. The ID always stays the same, but the Timestamp(obviously) and Amount are changing. eg: 2008-06-24 08:00:00 1 100 2008-06-24 09:00:00 1 176 2008-06-24 08:00:00 2 120 2008-06-24 09:00:00 2 134 I want to be able to be able to retrieve all the ID's where the amount hasn't changed in the last 72 hours. I have no idea how to approach this, so if anyone could point me in the right direction, I'd appreciate it very much. Link to comment https://forums.phpfreaks.com/topic/112693-compare-entries-72-hours-apart/ Share on other sites More sharing options...
Barand Posted July 1, 2008 Share Posted July 1, 2008 Double post - locked Link to comment https://forums.phpfreaks.com/topic/112693-compare-entries-72-hours-apart/#findComment-579366 Share on other sites More sharing options...
Recommended Posts