Removing last comma in PHP?

Question

I have this PHP code:

foreach( $wpdb->get_results(
) as $key => $row) {

echo "['". $row->DATE . "',". $row->total_sales . "],";

}

That produces this:

['09-08-11',0],['09-09-11',0],['09-10-11',0],['09-11-11',0],

How do I remove the last comma in the foreach loop?

Answer 1

There are a few approaches:

1. Push the strings into an array and use implode()
2. Add the bits to a string, remove the last character, then echo the string
3. Iterate more explicitly, and on the last iteration, don't output the ','

Of those options, I'd probably use #1, because it makes the code just a bit more self-documenting.