{$products[product].product}
 

I'm looking to modify the category pages and editing /skin1/customer/main/products.tpl.

Where are the values for {$products[product].product} taken from? Is it from /products.php? Is it from /home.php?

Not sure what you mean....what are you trying to achieve?

I would like to retrieve one row from the table xcart_images for each product displayed on the category pages. The template of course, for the category pages, is products.tpl.

I am trying to trace which of the php scripts is doing the queries and passing the retrieved values to products.tpl but only got as far as products.php and home.php. Once I found which php file is doing the queries, I could insert the required query there, too.

Liked your website, the one featured in your forum_profile.

I believe the query is in func.php which is called by search.php which is called by products.php

Thank you Jon. Found it.