Edited: Database lookup and display price with product number

[shanis42]

I have a customer that would like his parts displayed in grouped tables. I show a sample in the picture I attached. The attached image shows 45 different products. He doesn't want to show 45 individual listings, nor does he want to do it with combo-box attribute system. He is looking for a page (with something like the attached image) that has all in one table.

 

 

I am assuming I am going to have to do each grouping as its own page, which would be super easy if he wanted to show the part number or a button. Then its just setting up the link.

 

But, how would I show and link the products price instead of the part number? I am thinking it needs to be something like this:

 

$price = "SELECT price FROM products WHERE product=10045";
<a href="http://demostore.com/en/?product=10045>$price</a>

 

Then I would just print the "price" with a link to the products item page.

I don't know if prestashop is using straight mysql, or pear, or some other mysql package. 

 

Thank you in advance,

 

Edited May 27, 2014 by shanis42 (see edit history)