26 Jan 2008, 2:43 AM
New Zenner
- Join Date:
- Nov 2007
- Posts:
- 5
- Plugin Contributions:
- 0
Record Companies Sidebox - How to show with Only Available Items?
This is a question about Music (Product Type) sideboxes. They work fine I just want to get them to only list a Record Company / Genre / Artist if there is a related product in stock.
I guess it's dealt with here:
/includes/modules/sideboxes/
For record_companies.php
The area to edit is:
$record_company_query = "select record_company_id, record_company_name
from " . TABLE_RECORD_COMPANY . "
order by record_company_name";
Is that correct?
I think a product_status=1 needs to be added but I can't figure out how to link it up. A left join maybe?
I think the database tables that need to be read are: 'product_music_extra' and 'products'.
Has anyone already done this?--Reply with a link please..
Or any advice?
Thank you