Length of Product Name

robinakerr · November 2, 2006

I have some product names that are as big as 90 characters but they are being cut off at 64 characters. Can anyone explain to me how to lengthen the product names as they appear at the top of the page?

http://giftsofwine.com/osCommerce/catalog/...;products_id=56

will show you a truncated product name, the end should say Pinot Grigio

pyramids · November 2, 2006

this is set in the database. Use phpmyadmin to navigate to the correct table and change the max length of the appropriate fields.

robinakerr · November 2, 2006

this is set in the database. Use phpmyadmin to navigate to the correct table and change the max length of the appropriate fields.

Perfect! Thanks so much :D

fborille · November 3, 2006

Using the same thread ... to a diff question, how do i set the maximun leght that will be displayed and after it just cut off the rest ???

i'm having some trouble with the disign because some products uses 1 line for it's name and others uses 2, so how can i set it to 2 lines ? i can't figure it out :/

the site is www.slaveinformatica.com.br/lojavirtual

here's my new_products.php code:

<?php
/*
Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<tr>
 <td>
<?php 
 $info_box_contents = array();
 $info_box_contents[] = array('text' => '<table width="100%" border="0" cellpadding="0" cellspacing="0" height="24">
	<tr>
		<td><img src="images/left_header.gif" width="4" height="24" alt="" /></td>
		<td width="100%" style="background-image:url(images/header_bg.gif); color:#FFF; font-weight:bold; padding-left:5px;" align="left">'.TABLE_HEADING_NEW_PRODUCTS.'</td>
		<td><img src="images/right_header.gif" width="4" height="24" alt="" /></td>			
	</tr>
</table>'); 

 new contentBoxHeading($info_box_contents);
?>
<div style="border:1px solid #9FA0A6;margin-top:1px; height:auto;">
<?php 
 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$new_products_query = tep_db_query("select p.products_id, p.products_image, 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 where products_status = '1' order by rand() DESC limit " . MAX_DISPLAY_NEW_PRODUCTS);
 } else {
$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, 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_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $new_products_category_id . "' and p.products_status = '1' order by rand() DESC limit " . MAX_DISPLAY_NEW_PRODUCTS);
 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
$new_products['products_name'] = tep_get_products_name($new_products['products_id']);
$sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id;
$description_query = tep_db_query($sql);
$description = mysql_fetch_array($description_query, MYSQL_ASSOC);		
$description['products_description'] = substr($description['products_description'], 0, 65);
//	$description['products_description'] = substr(strip_tags($description['products_description']), 0, 65);
$desc_len = strlen($description['products_description']);
$description['products_description'][$desc_len-1] = '.';
$description['products_description'][$desc_len-2] = '.';
$description['products_description'][$desc_len-3] = '.';
if  ( ($col == 0 && $row == 1) || ($col == 2 && $row == 1) ){ 
$info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => 'width="1" height="100%" valign="middle"',
									   'text' => '<table height="" width="100%" border="0" cellspacing="0" cellpadding="0" >
 <tr>
<td><div style="width:1px"></div></td>
	 </tr>
</table>');
}
elseif (($col == 0 && $row == 1) || ($col == 2 && $row == 1)) {
$info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => 'width="1" height="100%" valign="middle"',
									   'text' => '<table height="" width="100%" border="0" cellspacing="0" cellpadding="0" >
 <tr>
<td style="border-top:1px solid #A7A9AC; font-size:1px;"> </td>
 </tr>
</table>');
}
elseif ($col == 1 && $row == 1) {
$info_box_contents[$row][$col] = array('align' => '',
									   'params' => '',
									   'text' => ' ');
}

else {	
$info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => 'class="main" width="235" height="2"  valign="top" align="center"',
									   'text' => '<table width="235" cellpadding=0 cellspacing=0 border=0 style="margin:5px 1px 5px 0px;"> 
									   				<tr>
														<td colspan="2" class="productName">'.$new_products['products_name'].'</td>
													</tr>
													<tr>
														<td colspan="2" height="1" background="images/points.gif"><img src="images/points.gif" width="3" height="1" /></td>
													</tr>
													<tr>
															<td height="98" rowspan="3"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="absmiddle"') . '</a></td>
															<td height="65" align="left">'.$description['products_description'].'</td>
													</tr>
													<tr>
														<td height="1" background="images/points.gif"><img src="images/points.gif" width="3" height="1" /></td>
													</tr>
													<tr>
														<td height="32" style="font-size:11px; font-weight:bold;">Pre?o:<span style="color:#C70000; font-size:14px; font-weight:bold;"> ' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span></td>
													</tr>
													<tr>		
															<td colspan="2" class="main" valign=top align="right" style="padding-right:10px; >'. tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')).'
																<table width="100%"  border="0" cellspacing="0" cellpadding="0">
																  <tr>	
																	<td style="padding-top:10px; padding-right:1px;" ><a href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'">'.tep_image_button('button_details.gif', IMAGE_BUTTON_DETAILS).'</a></td>
																	<td style="padding-top:10px;"><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_add_to_cart.gif', IMAGE_BUTTON_BUY_NOW) . '</a></td>

																  </tr>
																</table></form>
															</td>
														</tr>
													</table>'); }


$col ++;
if ($col > 1) { 
  $col = 0;
  $row ++;
}

 }
 new contentBox($info_box_contents, 0);

?>
</div>
</td>
</tr>
<!-- new_products_eof //-->

Thanks

Fabio.

Length of Product Name

Recommended Posts

robinakerr

pyramids

robinakerr

fborille

Archived

Browse

Activity