I am trying to find a way to run one code across multiple databases
I have a code that is scheduled to run on the 15th of each month and it will update a table in the database. - this works OK
what I now want to do is use the same scheduled file that contains the code to run this code for more than one database
the problem I am having is closing one database and moving to the next.......
I am trying
//connect to the first database
require('/home/xxx/yyy/htdocs/zzz/aaa/mysql_connect.php');
//run code
mysql_close();
require('/qqq/www/eee/htdocs/rrr/yyy/mysql_connect.php');
//run code
mysql_close();
but this give the error message
Warning: main(/qqq/www/eee/htdocs/rrr/yyy/mysql_connect.php): failed to open stream: No such file or directory in /(file that runs the code)/scheduler/15th.php on line 49
Warning: main(/qqq/www/eee/htdocs/rrr/yyy/mysql_connect.php): failed to open stream: No such file or directory in /(file that runs the code)/scheduler/15th.php on line 49
Fatal error: main(): Failed opening required '/qqq/www/eee/htdocs/rrr/yyy/mysql_connect.php' (include_path='.:/usr/local/lib/php') in /(file that runs the code)/scheduler/15th.php on line 49
Any ideas where I am going wrong
