Passing MySQL results as csv

[Anon]

Hi,

I'm sure this is PHP 101 question, with a simple answer, but for some reason I haven't been able to find an answer anywhere.

I am trying to have the results of a query return a comma separated list that can be used in an other function.

For example I would run a query:
$result = mysql_query ("SELECT isbn FROM items WHERE is_recommended='1'");

It will return about 5 isbn numbers that I need to list like so:

$isbns = "isbn1, isbn2, isbn3, isbn4, isbn4"

This is so I can use the array in a function like so:

$Reply = search_asin($isbns);

The echo the result or use it some place else.

At this point I have been able to get one isbn number from the table.

Any help would be appreciated.

Thanks
Victor

[tasistro]

Since each isbn is on different rows and a mysql dump call will return each row in a different line it is better to:

$result = mysql_query ("SELECT isbn FROM items WHERE is_recommended='1'");
$i=0;
while ($sql_row=mysql_fetch_array($result)) {
if ($i==0) {
$isbns = $sql_row["isbn"];
$i=1;
} else {
$isbns = ",".$sql_row["isbn"];
}

}

Saludos
Gerardo