PHP Timer to execute MySQL queries 5 minutes apart
Posted on 2009-03-31
I want to write a script, so when I call example.php that a MySQL query will execute, then the page will countdown 5 minutes (visibly) and then execute another MySQL query. I need to stagger these queries because of the strain it puts on the database. And I only want these queries to happen when someone calls up the web page example.php. This can not be done using Cron as I only want this to happen when someone calls the page.
I'm familiar with PHP somewhat and I know all my MySQL queries that I want to run, just not sure how to implement this timer.
Thanks for the input/help with this.