how to automatically run query

scorpioy

Some of you might know that many dating websites can performance so-called 'AutoMatch'. If you specify what type of people you would like to meet. The website will regularly do the query and find someone that matches your desire, and then email you the result.

Anyone knows how do they set and run such a regularly automatically query? How to set this in php+mysql?

silent

The only way to do automatic running of a PHP script would be
through a shceduled task (cron, for example)

If you are using a cheap hosting company, they probably don't
allow you to modify your crontab (that's the scheduling file)

If you are using something other than MySQL, I imagine this could
be written using DB triggers (everytime somebody adds/updates
a profile, it would check against everybody else's criteria)

scorpioy

Cron is used in Linux. I installed Apache and mysql in my WinXP. I want to practice this on my PC. How could I do automatic running of PHP script in my situation?

Thanks.

LordShryku

Windows has a built in task scheduler you can use...

scorpioy

I know there is built-in task scheduler in Windows. But how could I set it to run query? What I know for running query is to open the browser, fill some form, and click some button.

Sorry I'm brand new to this. Could you specify more detail on setting the task scheduler?

LordShryku

If this is a local script, make a batch file.

C:\php\php.exe C:\do\this\script.php

Then set the task schedular to run that batch script at your interval.

Shrike

FYI MySQL 5 is bringing stored procedures/triggers 🙂

Sharif

And that means?

LordShryku

They are ways to "trigger" another event. So to say, when so-and-so insert happens, you can tell mysql to delete something from some table, insert something in three other tables, update a few records in another table, so on and so forth.

MySQL is completely behind the times though, considering most RDMS's already have this.

Sharif

OH WOULD THAT MAKE LIFE EASIER!!!