Need help

[msdk]

Hi,

 

BEST_SELLERS.PHP issue!!!!!

 

product name is limited to a few letters and without manufacture name.

 

Example

01. Xbox 360 Pr....

 

Want to show best sellers like this centered with manufacture name and without the ....:

 

[01. Microsoft Xbox 360 Premium ]

[02. Tom Tom go930 gps EU incl TMC ]

 

I have a 250 width box, so space isnt a issue.

 

What code changes are needed to make this happen?

 

Here is my best_sellers.php code:

 

<?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 from " . TABLE_PRODUCTS . " p, " . 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 from " . TABLE_PRODUCTS . " p, " . 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 align="left">
<?php
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

new infoBoxHeading($info_box_contents, true, true);

$rows = 0;
$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="2" >';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
$rows++;
$str=(strlen($best_sellers['products_name'])>20)?(substr($best_sellers['products_name'],0,17).'...'):$best_sellers['products_name'];
$bestsellers_list .= '<tr><td class="infoBoxContents" valign="top" style="border-bottom:1px solid #a0a596"><b>' . tep_row_number_format($rows) . '.</b></td><td class="infoBoxContents" style="border-bottom:1px solid #a0a596"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '" class="bestsellers">' . $str .'</a></td></tr>';
}
$bestsellers_list .= '</table>';

$info_box_contents = array();
$info_box_contents[] = array('text' => '<div style="border:1px solid #a0a596; margin-top:1px; padding:1px 0px;">'.$bestsellers_list.'</div>');

new infoBox($info_box_contents);

?>
</td>
</tr>
<!-- best_sellers_eof //-->
<?php
}
?>