<?php

//Define an array to work with
$names = array();
$urls = array();


$query_name = mysql_query("SELECT cat_name FROM exp_categories JOIN exp_category_posts ON exp_categories.cat_id = exp_category_posts.cat_id WHERE entry_id = '{embed:entry_id}' order by exp_categories.cat_id DESC");
$query_url = mysql_query("SELECT cat_url_title FROM exp_categories JOIN exp_category_posts ON exp_categories.cat_id = exp_category_posts.cat_id WHERE entry_id = '{embed:entry_id}' order by exp_categories.cat_id DESC");

$count = '0';

while($count < '2'){
  $result_name = mysql_result($query_name,$count);
  array_push($names, $result_name);

  $result_url = mysql_result($query_url,$count);
  array_push($urls, $result_url);

  echo "<a href='{site_url}/" . $urls[$count] . "'>" . "$names[$count]" . "</a>, ";
  $count = $count + '1';
}
$result_name = mysql_result($query_name,$count);
  array_push($names, $result_name);

  $result_url = mysql_result($query_url,$count);
  array_push($urls, $result_url);

echo "<a href='{site_url}/" . $urls[2] . "'>" . "$names[2]" . "</a>";

?>