Feeding files separated by commas...

[nordicbeat]

Hi guys,
I hope someone can help me figure out my problem.
Soon I will open a MP3 download shop here in Sweden. To save time I use a
Script named LINKLOKURL. This script do magic for us how wants to email temporary links for download etc.

MY PROBLEM!

All files that the customer has chosen are stored in a mysql table. I pick up all entries with users session_id like this:

// CHOOSE ITEMS FROM TRANSACTION TABLE

$result = @("SELECT * FROM
Transactions WHERE TUID='$session_id'");

I’m echo out the result like this for testing the loop, it works fine!

// LOOP OUT THE RESULT

while ( $row = mysql_fetch_array($result) ) {
echo("<p>" . $row["Item"] .
"</p>");

Result:

NB018.zip

NB016.zip

NB030.zip

I need to feed these rows separated by commas like this:

“NB018.zip, NB016.zip, NB030.zip”

End then

$selectedfiles = "NB018.zip, NB016.zip, NB030.zip”;

There must be a simple task for this? 😕

Best,

// H. Sonesson

[tunage]

$selectedfiles = "";
$first = true;

while ( $row = mysql_fetch_array($result) ) {
if ($first) $selectedfiles .= $row["Item"];
else $selectedfiles .= ", " . $row["Item"];

$first = false;
}