foreach and impode help

[ATLien]

function tbag_categories() {
	global $wpdb;

$query = "SELECT DISTINCT $wpdb->term_taxonomy.term_id, $wpdb->term_taxonomy.taxonomy, $wpdb->terms.name FROM $wpdb->term_taxonomy
	LEFT OUTER JOIN $wpdb->terms  ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
	WHERE taxonomy = 'category' ORDER BY name ASC LIMIT 10";

$result = $wpdb->get_results($query);

foreach ($result as $category) {

	$tbag_cat_id = $category->term_id;
	$tbag_cat_name = $category->name;
	$tbag_cat_url = get_category_link($category->term_id);

	if ($category->term_id == '1') {
		$output .= '';
	} else {
		$output .= '<a href="' . $tbag_cat_url . '" title="' . $tbag_cat_name . '">' . $tbag_cat_name . '</a>';
	}

}

echo $output;
}

This produces a list of items:

FoodHotelCarPlane

I am trying to make it produce this:

Food, Hotel, Car, Plane

I want to use implode to add the coma and space, but I can not figure out where it will work in my code. I appreciate the help!

[tron00]

How about something like this?

$output = "";

foreach ($result as $category) {
	$tbag_cat_id = $category->term_id;
	$tbag_cat_name = $category->name;
	$tbag_cat_url = get_category_link($category->term_id);

if (empty($output)) {
	$output = '<a href="' . $tbag_cat_url . '" title="' . $tbag_cat_name . '">' . $tbag_cat_name . '</a>';
} else {
	$output = $output.', <a href="' . $tbag_cat_url . '" title="' . $tbag_cat_name . '">' . $tbag_cat_name . '</a>';
}
}

echo $output;

[ATLien]

That is not really what I am looking for. I am trying to seperate my links that are output by the foreach, with a (,) but not the last one:

TrainsPlanesAutomobiles <- This is what I get now

Trains, Planes, Automobiles <- this is what I want to get, note the commas dividing the items, but no comma at the end.

[tron00]

Right, that is what the code does

if (empty($output)) {
        // If $output is empty, it starts with the first link
        $output = '<a href="' . $tbag_cat_url . '" title="' . $tbag_cat_name . '">' . $tbag_cat_name . '</a>';
    } else {
        // If $output is not empty, then it adds the next link seperated by a comma
        $output = $output.', <a href="' . $tbag_cat_url . '" title="' . $tbag_cat_name . '">' . $tbag_cat_name . '</a>';
    }

[ATLien]

Thanks a lot, I didn't copy and paste the code correctly the first time. Thank you for the help!