Search code examples
phpsqltrim

Remove trailing comma from concatenated query string result

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.

Solution

  • 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);