time-arithmetic

comparing timestamps

HI, My php is very rusty and I can't quite remember how to do this. I have a script that i only want to call every 15 minutes. I've created a table called last_updated. What I want to do is have some code at the top of my script that queries this last_updated table and if now() minus the last updated is greater than 15 minutes then run ...

SQL time period query

I need to select from a table all rows that have date_added between CURDATE() and 6 weeks ago. Help please. ...