EchoFool Posted February 11, 2008 Share Posted February 11, 2008 Need some help, I have a query which when the report takes place I need to UPDATE all rows that are "before" the time that the query is run.. $Date = date("Y-m-d H:i:s",time()); Thats my time format. The rows contain a field "ReportedOn" so when the report completes... all rows that were reportedon "before" the process will change to what ever i need it to change to. This will help my staff from accidently reporting the same thing twice. Its just the WHERE clause i cannot figure out what do put Link to comment https://forums.phpfreaks.com/topic/90543-update-rows-before-now-time/ Share on other sites More sharing options...
revraz Posted February 11, 2008 Share Posted February 11, 2008 Use the < or > symbol Link to comment https://forums.phpfreaks.com/topic/90543-update-rows-before-now-time/#findComment-464202 Share on other sites More sharing options...
EchoFool Posted February 11, 2008 Author Share Posted February 11, 2008 Can it do that with time based? Cos thought that could only do it via number formats? Link to comment https://forums.phpfreaks.com/topic/90543-update-rows-before-now-time/#findComment-464203 Share on other sites More sharing options...
Barand Posted February 11, 2008 Share Posted February 11, 2008 UPDATE ... WHERE ReportedOn < NOW() Link to comment https://forums.phpfreaks.com/topic/90543-update-rows-before-now-time/#findComment-464340 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.