copied products to different category / display on copied products info page

[Cadoo]

hello

We are a CD music retailer who are about to start selling MP3 as well In some cases will will be selling a CD and MP3 of the same release.

Instead of a dropdown attribute we chose to have every product have it's own ID. In most cases we are copying CDs from the Compact Disc category to an MP3 category so they can keep the same model number and audio samples.

The one thing i am having a bit of trouble with is i would like to link to the same release's other formats. For example: if you are on a CD's page it would say "this release is also available as MP3" and vice versa.

We also need it to be dynamic to require no data entry like a xsell or the multixsell addons

i've searched around in the forums and faq for something like this and did not find much. I then started writing my own module but I seem to be caught up at an early stage as the query is not returning a result.

 $format_query = $db->Execute("select pc.categories_id, p.products_id, p.products_model, p.products_image, pd.products_name
                                 from ". TABLE_PRODUCTS_TO_CATEGORIES ." pc,  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                                 where p.products_model = '" . $_GET['products_model'] . "'
                                  and p.products_id <> '" . $_GET['products_id'] . "'"); 

Even though this is a rather esoteric addon i am working on i would like to offer it to the community once i get it finished.

Any help would be much MUCH appreciated

[stevesh]

Instead of a dropdown attribute we chose to have every product have it's own ID. In most cases we are copying CDs from the Compact Disc category to an MP3 category so they can keep the same model number and audio samples.

Can't help with the code, and I'm not sure exactly what the above means, but if the MP3's are separate products, could you just code a link to the MP3 into the CD product description ?