Record companies on product page

[doooomed]

I've seen this question before but I can't seem to find an answer. I would like the record company to show up on all my product pages. A previous post directed me to add to tmp_product_music_info_display.php but I don't know what to add. If this has been answered elsewhere apologies for asking again.

Also can this be a clickable link from the product page to show all items from that record company?

Any help is greatly appreciated!

[Ajeh]

You will need to jazz this up but more or less this should get the information you need that you can use on the tpl_product_music_info_display.php

with your templates and overrides using:

<?php
// bof: display record company name
  $sql = "select p.products_id, pme.record_company_id, rc.record_company_name
                            from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCT_MUSIC_EXTRA . " pme, " . TABLE_RECORD_COMPANY . " rc
                            where p.products_id ='" . (int)$_GET['products_id'] . "'
                            and pme.products_id = p.products_id
                            and rc.record_company_id = pme.record_company_id";

  $chk_record_company = $db->Execute($sql);

  echo '<div>' . 'Record Company: ' . $chk_record_company->fields['record_company_name'] . '</div>';
// eof: display record company name
?>

[doooomed]

Awesome Thank you!

Is there a way I can turn that into a link that would bring up all the product for that record company when clicked? Thanks again!

[Ajeh]

You should be able to use:

  echo '<div>' . 'Record Company: ' . '<a href="' . zen_href_link(FILENAME_DEFAULT, '&typefilter=record_company&record_company_id=' . $chk_record_company->fields['record_company_id'], $request_type, false) . '">' . $chk_record_company->fields['record_company_name'] . '</a>' . '</div>';

[doooomed]

Cool! Just bought you guys a coffee and donut

I added the second code and it comes up with the record company listed twice, like this...

Record Company: XYZ records (this one is clickable)
Record Company: XYZ records (not clickable)

How do I delete the second line?

[doooomed]

Never mind I figured it out...Thanks again!!!

[Ajeh]

Thanks for the update that this is working for you and thanks very much for the support ...

[doooomed]

How would I get a bullet on this? I can't seem to figure it out, everywhere I put the <li> tags I end up with a blank page. Thank you for any help!

[doooomed]

Still can't figure out how to get a bullet on this...anyone?



THANK YOU!