[RESOLVED] MySQL to CSV

[mpar612]

Hello,

I am in a bind here and need to be able to pull a bunch of email address from a MySQL db and export them as a .csv file.

The general idea behind this is that users will be filling out a form, which will add their email to the db. Then there will be an admin type person that can go to a web page and click something like "Generate .CSV" and PHP will get the emails from MySQL and put them into a csv file and a file download popup prompting the person to download the csv.

Does anyone have any thoughts or suggestions on this?

Thanks!

[mpar612]

I did some more messing around and have the following code posted below. This creates the csv file, but it is only returning one result.

Any thoughts. Thanks!

<?php

$selectSql = "SELECT artist_name FROM lounge_products";
$selects = $db->getAll($selectSql);

foreach($selects as $select) {

$content = $select[artist_name].",";

}

Header("Content-Disposition: attachment; filename=export.csv");
print $content;
?>

[xblue]

Not so much a csv generation issue, part of your problem seems that you are overwriting $content all the time. You'd probably want to use the concatenation operator to add to it rather?

$content .= $select[artist_name].",";

I'd do it slightly different though, like

$content[] = $select[artist_name];

and then outside the loop

implode(',', $content);

[mpar612]

I tried both ways and they both worked perfectly. Thanks for your help!