steiny.net

“He has faith and he’s willing to act on it.”

–Brandon J. Rusche on George W. Bush during the 2004 election

I say he had blind faith and stupidly followed it.  I mean Rusche and Bush both…

2/3 Cup margarine
1 Cup sugar
1 Cup brown sugar
2 eggs
2 tsp vanilla
4 tblspoons water
2 cups flour
2 1/2 tsp baking powder
1/2 tsp salt
2 cups chocolate chips

Mix in order. Bake at 350 degrees in 9 x 13 pan 25-30 minutes.

Good muzak

http://www.brettdennen.com/

I had a tough time finding a quick example of dumping a MySQL table to Excel using PEAR Spreadsheet_Excel_Writer so here is what I came up with. Very handy and I hope it helps somebody looking for the same thing.

< ?php require_once 'Spreadsheet/Excel/Writer.php'; require_once 'DB.php'; require_once 'DB/Table.php'; // create a PEAR DB object $dsn = "mysql://user:password@www.host.com/database"; $db = DB::connect($dsn); $select = "SELECT * FROM tablename"; $export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) ); $fields = mysql_num_fields ( $export ); $xls =& new Spreadsheet_Excel_Writer(); // Send HTTP headers to tell the browser what's coming $xls->send(“test.xls”);

// Add a worksheet to the file, returning an object to add data to
$sheet =& $xls->addWorksheet(‘worksheetname’);

$format_bold =& $xls->addFormat();
$format_bold->setBold();

for ( $i = 0; $i < $fields; $i++ ) { $sheet->write(0, $i, mysql_field_name($export,$i),$format_bold);
}

$r = 1;
$c = 0;

while( $row = mysql_fetch_row( $export ) )
{
foreach( $row as $value )
{
if ((isset($value)))
{
$sheet->write($r,$c,$value);
$c++;
}
}
$r++;
$c = 0;
}

// Finish the spreadsheet, dumping it to the browser
$xls->close();
?>

The Bank of America in Washington state (and I believe Idaho) is a perfect example of a disasterous merging (or lack thereof) of information systems.  They have lost me as a customer due to the poor interoperability of WA and every other state’s computer systems.  It is impossible for me to make a deposit at an out of state ATM.  It is also impossible to find a phone number to cancel my account.

Grr….