Automatic Scheduling

[Jackus]

Hey guys,
Just wondering how I would go about scheduling events in MySQL/PHP so that an event (say, every weekday or every wednesday) can be retrieved from a MySQL database without having to manually input every entry.

Is there a schedule function, or anything?

Many thanks.
Jack

[CloudedVision]

Originally Posted by Jackus

Hey guys,
Just wondering how I would go about scheduling events in MySQL/PHP so that an event (say, every weekday or every wednesday) can be retrieved from a MySQL database without having to manually input every entry.

Why would you have to manually input each event to retrieve an event?

[alexgeek]

To do this you would have to setup a cron job that will visit the page that executes the query.
There may be a better way to set this up though, what is the purpose of this?

[Jackus]

I see...
Well, I am trying to code a tournament site, where they can see what tournaments are being played.
For this, I need to input the tournaments into the database, but some are recurring - and I really dont want to have to input manually every day/week etc.

So, what would I do with teh MySQL database to know that the event is recurring every wednesday, for example? How would the cron job script work?

[CloudedVision]

Most hosts have a cron job option on their CP. Just have it run a PHP script that inserts the tournament.