HOW? Echo the categories_name in products_attributes.php for a Product

[screenprintdude]

Where all the products get listed to add the attributes, I've already added the PRoduct Model to make finding items easier for me. I also need to Echo the Category Name that the product is in. We may have a product listed 2 or three times in various categories as it's own product not a link. We do this to control the options available to Specific Customers in the SPPC / Hide Products and Categories from Customer. So if I need to have Product A with different Options for Customers A and B, I also need to see the category name the product is in so I know which product level I am editing options for.

 

I've fuddled my way through the queries and I just can't seem to match up the right fields to grab the categories_name from the categories_description table using the

 

  $attributes = "select pa.*, pd.products_name from " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pa.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name";

 

that grabs everything else. I don't think I quite grasp how to work my way backwards from pd.products_id to a matching category name for the same product