Show the image of the product on confirmation page

[axioma]

I want to show images of the products on confirmation page.in this way the customer can be secure about his buying decision.

 

On catalog checkout_confirmation.php

I found

 

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

echo ' <tr>' . "\n" .

 

after that I added

' <td class="main" valign="top">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $order->products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' .

 

 

The problem is that the imagen is not showing

I wonder that could be because $products[$i]['image'] does not have connection with the order but $order->products[$i]['image'] neither.

 

How can I call the correct database imagen…?

 

Or better yet, how can I show the imagen of the product on confirmation page?

[web-project]

you need to add to SQL query to look up the products_image filed.

[axioma]

you need to add to SQL query to look up the products_image filed.

 

ok but which one???...

 

$products[$i]['image'] ???

[axioma]

no one?