Hi All,
I need to take a record in MySQL and have my user get it as a CSV
File. I am OK with most everything, except when I create the CSV file,
I write out the column headers then I need to write out the data.
After I right out the column headers do I have to put a '/n' to have
it start a new line in the CSV file? I think I do.
Here is what I have (a snippet):
header("Content-type: application/csv");
header($filenameString);
header("Pragma: no-cache");
header("Expires: 0");
echo $map_BORROWER_FIRST_NAME.", ";
echo $map_BORROWER_LAST_NAME.", ";
echo $map_BORROWER_SSN.", ";
echo $map_BORROWER_HOME_PHONE.", ";
echo $map_BORROWER_DOB;
echo "/n";
echo $row[BORROWER_FIRST_NAME].",";
echo $row[BORROWER_LAST_NAME].",";
echo $row[BORROWER_SSN].",";
echo $row[BORROWER_HOME_PHONE_FIRST].$row[BORROWER_HOME_PHONE_MIDDLE].
$row[BORROWER_HOME_PHONE_LAST].",";
echo $row[BORROWER_DOB_MONTH].$row[BORROWER_DOB_DAY].
$row[BORROWER_DOB_YEAR];
When I run this, I see my column names, but not the data. The query
seems to execute just fine....
Any advice?
Thanks,
-Jason
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
