PHP Code:
<?php
$products 
$db->Execute("SELECT products_image
FROM " 
TABLE_PRODUCTS "
WHERE products_id ='" 
$order->products[$i]['id'] . "'");

echo 
'<span class="cartProductDisplayXXX">' zen_image(DIR_WS_CATALOG DIR_WS_IMAGES $products->fields['products_image'] , $order->products[$i]['name'], SMALL_IMAGE_HEIGHTSMALL_IMAGE_WIDTH) . '</a></span>&nbsp;';
?>
maybe this will work? I dunno?

tell me where you're putting the code and I'll try to do it as well.