CSV output

[Steven Paul]

I need to write the output of an SQL query as comma-separated values.
So I wrote this, which is almost right:

while($row = mysql_fetch_array($rs, MYSQL_ASSOC))
{
$rows[] = $row;
}
foreach( $rows[0] as $key =$value)
{
echo $key.",";
}
echo "\n";

foreach ($rows as $row)
{
foreach( $row as $key =$value)
{
echo $value.",";
}
echo "\n";
}
It first writes a header row, then all the data rows below it. The only
problem is the trailing comma on each line. Is there some clever way of
knowing when I'm on the last element, and so not add the last comma?

If it's not already blindingly obvious, I'm new to PHP ;-)

Thanks,
-Steve

[Geoff Berrow]

Message-ID: <19****************************@fastOUTmail.fmfr om Steven
Paul contained the following:

>It first writes a header row, then all the data rows below it. The only
problem is the trailing comma on each line. Is there some clever way of
knowing when I'm on the last element, and so not add the last comma?

http://uk2.php.net/implode

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Steven Paul]

In article <q7********************************@4ax.com>, Geoff Berrow
<bl******@ckdog.co.ukwrote:

Is there some clever way of
knowing when I'm on the last element, and so not add the last comma?

http://uk2.php.net/implode

Wow, this PHP has everything ;-)

Thanks Geoff.

[Colin Fine]

Steven Paul wrote:

In article <q7********************************@4ax.com>, Geoff Berrow
<bl******@ckdog.co.ukwrote:

>>Is there some clever way of
knowing when I'm on the last element, and so not add the last comma?

http://uk2.php.net/implode

Wow, this PHP has everything ;-)

Thanks Geoff.

It got it from Perl! ;-)

Colin

[Marcin Dobrucki]

Steven Paul wrote:

I need to write the output of an SQL query as comma-separated values.
So I wrote this, which is almost right:

while($row = mysql_fetch_array($rs, MYSQL_ASSOC))
{
$rows[] = $row;
}
foreach( $rows[0] as $key =$value)
{
echo $key.",";
}
echo "\n";

foreach ($rows as $row)
{
foreach( $row as $key =$value)
{
echo $value.",";
}
echo "\n";
}

You are reinventing the wheel:

SELECT * INTO OUTFILE "/tmp/outfile.csv" FIELDS TERMINATED BY "," FROM
<yourtable>;

There are also a number of options on enclosing fields, specifying
newlines and so on.

/m

[Steven Paul]

In article <9b********************@news1.nokia.com>, Marcin Dobrucki
<Ma*************@TAKETHISAWAY.nokia.comwrote:

SELECT * INTO OUTFILE "/tmp/outfile.csv" FIELDS TERMINATED BY "," FROM
<yourtable>;

Thanks. I didn't know about that.