how to add product image to the template header

[weber]

I want to show the product(shopping cart items) images on header of my site. I find that

$productArray[$i]["productsImage"]

can display the images, however, it comes with the width/height of the photo, how to get the product images url only....

[Absolute]

The easest way is to create your own array, using an SQL query. You can then decide if you want specific products, or a random selection drawn from the database.

You just need to obtain the products_image variable from the products table within the database.

$header_products_rs = $db->Execute("select p.products_image, pd.products_name from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd where p.products_id = pd.products_id and pd.language_id = '".(int)$_SESSION['languages_id']."' order by rand() limit 1");
echo zen_image(DIR_WS_IMAGES.$header_products_rs->fields['products_image'], $header_products_rs->fields['products_name']);

Please note that this code has not been tested, and is meant only as a pointer in the right direction.

Absolute