RE: [PHP] Print MySQL DB as Exel File?

I didn't think they were useless. Jason said he would post some code if I wanted. Yes, I would like to see it. Pierre's post was very helpful and is the solution I will use for now. ren's posts were a little over my head. :) I'm sure you're really smart but not very helpful for someone new like me. Jeff Oien > I know very little about php, but since you have already received a bunch of > useless answers, I thought I add my guesswork. > > In php 4 you can access MS documents through Microsofts OLE interface. That > means you can manipulate an .xls file as you would be able to in > VisualBasic. You should look for something called COM in your documentation. > > I should add that I have never done it in php, only in perl... > > Goodluck > > > -ren > > > Could anyone help me out with how to print the entire contents of a > > database as an Excel file? I'm familiar with the header: > > > > header("Content-Type: application/vnd.ms-excel"); > > > > just not sure how to go about it beyond that. I have this code and > > am not sure what do do after it. Thanks. > > Jeff Oien > > > > while ($row = mysql_fetch_array($result)) { > > $Event = $row['Event']; > > $First_Name = $row['First_Name']; > > $Last_Name = $row['Last_Name']; > > $Title = $row['Title']; > > $Organization = $row['Organization']; > > $Phone = $row['Phone']; > > $Email = $row['Email']; > > $date = $row['date']; > > $id = $row['id']; > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >