Write Forums

Print out contents of to Excel

Posted on 16th Feb 2014 07:03 pm by admin

I have got this script that gathers all the data that I need but I need it to send it to excel instead back to the screen in the web browser. How can I do this? Should I use something like:

$csv_output .= "n";

Here is my code:

// Make a MySQL Connection
// Construct our join query
$query = "SELECT sunocoimport.duns_num, custmast.gl_num, custmast.division_num, custmast.customer_num, sunocoimport.summary_date, sunocoimport.cc_fees, custmast.fee_percent, custmast.clear FROM sunocoimport, custmast WHERE sunocoimport.duns_num = custmast.duns_num AND (sunocoimport.cc_fees * custmast.fee_percent / 100) <> 0";

$result = mysql_query($query)or die(mysql_error());

// Print out the contents of each row into a table
while($row = mysql_fetch_array($result)){
echo $row['division_num'].",".$row['customer_num'].",".$row['summary_date'].",".round($row['cc_fees'] * $row['fee_percent'] /100 , 2) .",".$row['clear'].",".$row['gl_num'];
echo "<br />";
}
?>

Thanks for your help!

No comments posted yet

84 12 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Legal Issues for SAP ERP o ERP in general 
Hi experts,



Can someone please help me finding some documentation about legal issues tha 
"From field" in PHP email form 
I used a wizard to create a PHP email form.  I was able to customize it with the exception of the Fr
Must-Know Topics of PHP 
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of
ob_ dynamic content 
i was wondering about the potential to use ob to create a  <div then remove it when the page 
Else statement screws up all css 
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing
Help If user voted, block them 
On my Prayer request site, i let users Click a button to Pray for somone that has posted a pray, i g
How to read CSS message data 
Hi,

I have a requirement here. When working as a Dev angel for multiple customers its really di
login to other site by sending post variables 
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us 
Get word number x from string? 
How can I use a function to loop through a string, and "have a look at" every word in the