从连接的查询字符串结果中删除尾随逗号

Question

hope you can help, tearing my hair out here!

I have...

$result = mysqli_query($con,'SELECT this FROM that');

while($row = mysqli_fetch_array($result)) 
    {
        echo $row['this'] . ',';
    }

Which returns... 222,225,243,256,260,269,273,280,295,296,

I need to remove the last comma to give me just... 222,225,243,256,260,269,273,280,295,296

I've tried trim rtrim substr and everything else I could find but none of them work. Think it's to do with the concatenation of the $row['this'] . ',' but I cant figure out how to resolve it!

Any help would be appreciated.

Cheers, Mark.

Answer 1

you can use implode

while($row = mysqli_fetch_array($result)) 
    {
        $a[]= $row['this'];
    }

$b = implode(',',$a);

print_r($b);

function for implode

function imp($c){
        $d= implode(',',$c);
        return $d;
    }


$b = imp($a);

print_r($b);