Objective: Show links to all products with same Model# in product info page... in a layout similar to "additional images" I suppose.

How: Possibly required modification in tpl_product_info_display.php

Here's my database setup...

Code:
Model#  Product_Name
TE3523 	TE3523 - CITRINE(EARRING 18K)
TE3523 	TE3523 - GREEN AMETHYSTTHYST(EARRING 18K)
TE3523 	TE3523 - LEMON QUARTZ(EARRING 18K)
Basically each model # has various color options... Therefore when I click on a product I want the images & links for all the color options for that particular model....

I know this can be done via attributes somehow, but customers need to see images for each type of color... and pricing is complicated and done externally based on color..etc.
So I already have some VBA code to convert my excel data into SQL (which I can put here for folks interested, though its specific to my test case).
I was wondering there must be an easy way to use PHP and achieve my objective.

When I click on a product ... for e.g. "TE3523 - CITRINE(EARRING 18K)"
I want links to appear on the bottom of the page to all other products with the same model #...

I looked at tpl_product_info_display.php... and i think it would be cool if i could have the other products display like the additional images section, which is shown below
Code:
<!--bof Additional Product Images -->
<?php
/**
 * display the products additional images
 */
  require($template->get_template_dir('/tpl_modules_additional_images.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_additional_images.php'); ?>
<!--eof Additional Product Images -->
which in turn calls the tpl_columnar_display.php...

Code:
<div id="productAdditionalImages">
<?php
  require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php'); ?>
</div>
which means i have to call the columnar display but with my parameters...

now the question is how to get the list of all products with the same model# as the current product...
If SQL
Code:
 
SELECT products_image FROM products where products_model = [currentmodel];
I really don't know PHP and this is all i could figure out... that i probably want to call columnar display and pass it the correct paramters...

now if someone can tell me the correct way to query the database and get the desired records... and then call the template correctly, then i can probably get this working quickly.
Please let me know oh you zen masters!