Show hole category-path in mail to admin?

[dhotter]

Again, again a problem:

 

An e-mail is send to an admin by this code:

 

          define(EMAIL_TEXT_SUBJECT,'New Product was added');
         $category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id ."'");
         $category = tep_db_fetch_array($category_query);

         $email =  "Hello administrator\n\n";
         $email .= "New product was added to : ".$category['categories_name']."\n\n";
         $email .= "Product was added by : ". $customer['customers_firstname'].' '.$customer['customers_lastname'] ."\n\n";
         $email .= "For approve new product go to administrator panel \n\n";
         tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_TEXT_SUBJECT, $email,$customer['customers_firstname'].' '.$customer['customers_lastname'],$customer['customers_email_address']);

 

The query, which shows the category doesn't show the main-category and the sub-categories. Only the last sub-category.

 

Is it possible to show all categories? Main and sub?

 

Thanx for your support!

Dan

[dhotter]

Do I only have to change the 'categories_name'?

[dhotter]

Sorry, I forgot to say, this code is from the contrib

Customer add product

 

Maybe this could be important for a solution for my problem with the incomplete category-path!?

 

Greetings,

Daniel