[Resolved] Auto-Update Database

[Trs2988]

I have a website that uses PHP and MySQL, and what I'm trying to do is make it so that at midnight (even if no one accesses the page), either PHP or MySQL updates the database with new numbers, etc. For example, say a person only has a certain amount of posts a day. At midnight, I would like their amount of posts for the day reduced to zero, so they can post again.

This may be a newbie question, but since it dealt with databases I thought it might belong here. 😕

If anyone can help me here with a way to do that, I would greatly appreciate it. Thanks.

[Pig]

Simple solution. Just write your script in a PHP file, so that when the PHP file is called, it does the actions you want. Put this file OUTSIDE of your htdocs folder. To automate it, check out CRON. You can find lots of good stuff on google.

[Trs2988]

Thanks, that's what I was looking for. This "cron" seems a little bit complicated for me, since reading about it is making my head spin, but I'll figure it out eventually. 😃

Thanks again.