Search found 2 matches

by ERuiz
Sun Apr 08, 2007 7:59 pm
Forum: Databases
Topic: Delete record if older than 5 minutes?
Replies: 2
Views: 424

Thanks for the reply, but the previous code is now working! I switched the last_update flag to timestamp and now it's working. I had it as varchar. Maybe that was it.
by ERuiz
Sun Apr 08, 2007 7:10 pm
Forum: Databases
Topic: Delete record if older than 5 minutes?
Replies: 2
Views: 424

Delete record if older than 5 minutes?

Can someone help me with deleting a record, when that record is older than 5 minutes? Someone gave me this query: $query = "DELETE FROM liveacars WHERE last_update < NOW() - INTERVAL 300 SECOND"; But when I execute it, it does not delete the records. FYI, the last_update field is set as ti...