*SOLVED* php/mysql display help

[birdie]

hi, i'm sure this is easy but i have completely forgot how to do this kind of thing so i'm after help :-).

i have a column that is named 'pid'.

[code]
while($row = mysql_fetch_array($sql)
{
echo $row['pid']; //this gives all of the pid's..
}
[/code]


how could i echo the pid's like this..

1,2,3,4,5 insead of 12345?

thanks alot!

[wildteen88]

Simple do this:
[code]while($row = mysql_fetch_array($sql))
{
    echo $row['pid'] . ',';
}[/code]and you'll get a result of 1,2,3,4,5,

If you want to not show the ending , after 5 then do this:

[code]$pid = ''; //setup the variable pid
while($row = mysql_fetch_array($sql))
{
    $pid .= $row['pid'] . ',';
}
//this removes the last character from value in $pid
$pid = substr($pid, 0, strlen($pid)-1);[/code]
You should now get a result like 1,2,3,4,5

[birdie]

[!--quoteo(post=353951:date=Mar 11 2006, 04:44 PM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ Mar 11 2006, 04:44 PM) [snapback]353951[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Simple do this:
[code]while($row = mysql_fetch_array($sql))
{
    echo $row['pid'] . ',';
}[/code]and you'll get a result of 1,2,3,4,5,

If you want to not show the ending , after 5 then do this:

[code]$pid = ''; //setup the variable pid
while($row = mysql_fetch_array($sql))
{
    $pid .= $row['pid'] . ',';
}
//this removes the last character from value in $pid
$pid = substr($pid, 0, strlen($pid)-1);[/code]
You should no get a result like 1,2,3,4,5
[/quote]
ok thanks!

[kenrbnsn]

A different way is to use a temporary array and the implode() function:
[code]<?php
$tmp = array(); // make sure we start with an empty array
while($row = mysql_fetch_array($sql))
{
    $tmp[] = $row['pid'];
}
$pid = implode(',',$tmp);
?>[/code]

Ken