Updating Values automaticly

xdentan

How can I have a database set up that automaticly changes a value at the end of the day, for example tracking how many hours a user has been online, and at 12:00 it sets all the values in the column "hours" to 0, except I want it to do this without any one having to manually typing the code when it is 12:00 (I want it automated so I do not have to input code at 12:00 or open a webpage at 12:00).

drawmack

On unix: cron job

On windows: task scheduler

xdentan

Originally posted by drawmack
On unix: cron job

On windows: task scheduler

well... I am talking about a mySQL database on a free server I found located who knows where, so I do not really have access to the task schedular, or cron job (and I dont know if the server is windows or linux). Is it possible to set this via php, or something?

drawmack

create a page that needs to be browsed to, then on your local machine schedule a task that will fire up IE and go to the page.

xdentan

...that sounds like a great idea, but that means I will have to have my computer on all night after I go to bed, and will have to be connected to the internet all that time, are there any other options?

drawmack

well you could host with a real provider, or you could schedule the task to run at a time when you're normally online anyway.

xdentan

Originally posted by drawmack
well you could host with a real provider, or you could schedule the task to run at a time when you're normally online anyway.

...thanks for the help, but with a paid host do you normally get the administrative privllages to schedule tasks on the servers?

also what would you suggest for a server I could do this on?

drawmack

yes most paid hosts give you full access I recommend http://www.liquidweb.com