Jump to content

Update rows "before" now time.


EchoFool

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.