Re: [PHP-DB] CURDATE()

2011-08-18 Thread Geoff Lane
On Thursday, August 18, 2011, Ron Piggott wrote; > What I tried below doesn’t work: ( CURDATE() . % ) Even though date values are presented like strings, they are dates/times. So you need to either cast CURDATE() to a string or else perform 'date arithmetic'. Check the manual for DATEDIFF(), CAS

[PHP-DB] CURDATE()

2011-08-18 Thread Ron Piggott
I am setting up a daily cron job to update the site map on my web site. I want to delete any records that weren’t updated by the cron job each day. The way I can distinguish this is with the timestamp column named “last_record_update” If a record wasn’t updated it is no longer part of the