Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Record companies on product page

    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!

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Record companies on product page

    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:
    Code:
    <?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
    ?>
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Record companies on product page

    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!

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Record companies on product page

    You should be able to use:
    Code:
      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>';
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Record companies on product page

    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?

  6. #6
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Record companies on product page

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

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Record companies on product page

    Thanks for the update that this is working for you and thanks very much for the support ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Record companies on product page

    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!

  9. #9
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Record companies on product page

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

    Name:  Untitled.jpg
Views: 66
Size:  19.7 KB

    THANK YOU!

 

 

Similar Threads

  1. v150 Record companies and product listing
    By doooomed in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 14 Dec 2012, 03:09 PM
  2. Product music not showing artists nor record companies images?
    By Ishtar in forum Setting Up Categories, Products, Attributes
    Replies: 9
    Last Post: 10 Feb 2010, 07:09 PM
  3. Record Companies side box
    By Sushigal in forum General Questions
    Replies: 4
    Last Post: 14 Jul 2009, 12:39 PM
  4. Replies: 1
    Last Post: 19 Jun 2006, 12:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR