prototype of PHP script
$db_stack=array("ip,user,pass,dbname,table","ip2,user2,pass2,dbname2,table2"
,...);
$resultset=array();
foreach($db_stack as $k=>$v){
/// query database and get results
$resultset[].=$portion_of_information;
}
foreach($resultset as $k=>$v){
//append row and save as csv file
}
regards,
Khazret Sapenov
----- Original Message -----
From: "David Mohorn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 16, 2004 12:58 PM
Subject: Database Stats
>
> I have about 25 databases that I need to run the same query against that
> returns about 5 columns of information.
>
> I need this information then published within an Excel spreedsheet.
>
> What is the best way do handle this?
>
> Currently, I'm running each query manually, copying/pasting the result
> to Excel, and repeating...
>
> I need to run this procedure every week, and it takes a considerable
> amount of time.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
