I'm looking for info on how to do this but i am just wondering would it be a hard task to complete: I want to create a query that will select the account that has the highest score, then display the persons photo on a my home page everyday. I want this task to be carried out each day at midnight. Am i pushing the boat out here a little or is this quite easy 1. very difficuly or 2. quite easy
Quite easy. But then, thats me. I don't know what your skill-level is. The easy way is to make a normal php-page that does what you wan't and then call it every day at midnight. Either in a browser or via cron. This command will probably do what you want after you create the script: curl http://domain.tld/yourscript.php Stick it in a cronjob that fires every midnight and you're golden.