Jump to content
Sign in to follow this  
goodebox

Displaying Images in the Bestsellers box

Recommended Posts

Hi All,

 

Im attempting to display small product images in my bestsellers box. I'm using combination of the Bestsellers Display Enhancement + Bestsellers Display with prices Contributions. Below is the code. The protion that controls imaging (line 34) seems to be absolute, and images are not being displayed. Instead im getting the small box with the red X inside. When I check properties of the image, it only shows the path specified in the code, and is not dynamically picking up the product information. Is someone familiar with how this coding should go to pick up the correct product image?

 

<?php

/*

$Id: best_sellers.php,v 1.21 2003/06/09 22:07:52 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

if (isset($current_category_id) && ($current_category_id > 0)) {

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);

} else {

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);

}

 

if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {

?>

<!-- best_sellers //-->

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

 

new infoBoxHeading($info_box_contents, false, false);

 

$rows = 0;

$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';

while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {

$rows++;

$bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">' . '.</td><td class="infoBoxContents"><img src="/catalog/images"> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '?</a>?' . $currencies->display_price($best_sellers['products_price'], tep_get_tax_rate($best_sellers['products_tax_class_id'])) . '</td></tr>';

}

$bestsellers_list .= '</table>';

 

$info_box_contents = array();

$info_box_contents[] = array('text' => $bestsellers_list);

 

new infoBox($info_box_contents);

?>

</td>

</tr>

<!-- best_sellers_eof //-->

<?php

}

?>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×