Automation of Reports

[H4tch3tM4n]

Hi guys,

I need to send a report once a week making use of MySQL queries(preferably an automated report).
The installtion is running from a windows machine, so I have no easy way of just passing the commands to MySQL like I could have done on a *nix box.
Can someone perhaps enlighten me to a way of doing this from the windows machine with minimal effort...?

Thanx

[cas]

You can use Scheduled tasks to run anything on a regular base, also PHP scripts.
here is a sample:

REM *** this batch is running as a scheduled task under the ... Account ***
g:
cd \inetpub\wwwroot\mantis
php.exe my_weekly_report.php