Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem displaying description


nahi_sonu

Recommended Posts

Posted

hi,

i m being working on oscommerce for so many days now.. but im having problem with my index file..

whenever i add products to my website.. there is problem on the the displaying of the product.. i mean the description of the product goes funny!

it keeps on changing the font and style of the description!

if u can have a look at

http://www.redentor.co.uk

im using tiny mce editor.. and i have used same text settings for all the products.. but the products displaying on the website are not showing the text properly!

if u just look at the website.. you'll be able to see wht i mean!

and now i dont know where to look at!

please help me .. i need to get live as soon as possible!

thanks

bbye

outside links are not allowed in signatures

Posted
hi,

i m being working on oscommerce for so many days now.. but im having problem with my index file..

whenever i add products to my website.. there is problem on the the displaying of the product.. i mean the description of the product goes funny!

it keeps on changing the font and style of the description!

if u can have a look at

http://www.redentor.co.uk

im using tiny mce editor.. and i have used same text settings for all the products.. but the products displaying on the website are not showing the text properly!

if u just look at the website.. you'll be able to see wht i mean!

and now i dont know where to look at!

please help me .. i need to get live as soon as possible!

thanks

bbye

 

I have had a look at your site and see what you mean.

 

I had a similar problem last year on one of the first sites I built

It was caused by changing the currncy module from USD to GBP , I lost all my prices and a couple of my products.

I took the drastic action of scrapping the site and starting all over again ( Which I do NOT suggest you do )

If you have backup copies of index.php and english.php try writing over them - it may help

Life is the greatest gift there is - Make the most of yours

Posted

I'm getting this error message when trying to access your site right now:

 

Parse error: syntax error, unexpected '<' in /home/bmamen/public_html/index.php on line 528
Posted

The problem I can see is with some styles you have hard-coded, e.g.,

 

<td width="157" height="52" style=" vertical-align:middle;">

and

<table cellpadding="0" cellspacing="0" border="0" style=" width:10px;">

 

to note a few.

 

Better:

<td width="157" height="52" valign="middle">

<table cellpadding="0" cellspacing="0" border="0" width="10">

 

Hard-coded styles are not formatted the same as stylesheets so take care.

 

I hope this helps.

 

jon

It's all just ones and zeros....

Posted
I'm getting this error message when trying to access your site right now:

Parse error: syntax error, unexpected '<' in /home/bmamen/public_html/index.php on line 528

 

i was trying doing some corrections to the index file.. thats why u were getting error.. but its back now...

 

and about replacing the index.php and english.php files.. i have tried them.. but not working

 

here is the index.php of my site

 

<?php
/*
 $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

// the following cPath references come from application_top.php
 $category_depth = 'top';
 if (isset($cPath) && tep_not_null($cPath)) {
$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
$cateqories_products = tep_db_fetch_array($categories_products_query);
if ($cateqories_products['total'] > 0) {
  $category_depth = 'products'; // display products
} else {
  $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
  $category_parent = tep_db_fetch_array($category_parent_query);
  if ($category_parent['total'] > 0) {
	$category_depth = 'nested'; // navigate through the categories
  } else {
	$category_depth = 'products'; // category has no products, but display the 'no products' message
  }
}
 }

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<TITLE><?php echo $titletag; ?></TITLE>
<meta name="robots" content="index, follow" />
<META NAME="Keywords" content="<?php echo $keywordtag; ?>">
<META NAME="Description" content="<?php if (tep_not_null($cat_description['categories_description'])){
echo (strip_tags($cat_description['categories_description']));
} else { echo $description; }?>">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
  <td valign="top">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</td>
<!-- body_text //-->
<?php
 if ($category_depth == 'nested') {
$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category = tep_db_fetch_array($category_query);
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">



<?  tep_draw_heading_top();?>



<? new contentBoxHeading_ProdNew($info_box_contents);?>



<?  tep_draw_heading_top_1();?>









				<table border="0" cellspacing="2" cellpadding="0" align="center" class="box_width_cont product">



					<tr>

<?php
if (isset($cPath) && strpos('_', $cPath)) {
// check to see if there are deeper categories within the current category
  $category_links = array_reverse($cPath_array);
  for($i=0, $n=sizeof($category_links); $i<$n; $i++) {
	$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
	$categories = tep_db_fetch_array($categories_query);
	if ($categories['total'] < 1) {
	// do nothing, go through the loop
	} else {
	$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
	break; // we've found the deepest category the customer is in
	}
  }
} else {
  $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
}

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;
while ($categories = tep_db_fetch_array($categories_query)) {
  $rows++;
	$cPath_new = tep_get_path($categories['categories_id']);
  $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
  echo '			   
		<td  align="center" width="' . $width . '">'.tep_draw_prod_top().'

				<table cellspacing="0" cellpadding="0" border="0" >

					<tr>

						<td width="157" height="47"><br style="line-height:15px">

						 <a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a></td>

					</tr>

					<tr>

					  <td width="157" height="150" class="pic" align="center"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '</a><br></td>

					</tr>

				</table>			

		'.tep_draw_prod_bottom().'



		</td>



  ' . "\n";

			  if ($col!=(MAX_DISPLAY_CATEGORIES_PER_ROW-1)){

			  echo '

										<td>'.tep_draw_separator('spacer.gif', '12', '1').'</td>

										<td class="bg6">'.tep_draw_separator('spacer.gif', '1', '1').'</td>

										<td>'.tep_draw_separator('spacer.gif', '16', '1').'</td>

					';

			  }

			 else{				  



  if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

	echo '			  </tr><tr><td colspan="9"> </td></tr>' . "\n";

	echo '			  <tr>' . "\n";

  }

}

if ($col==MAX_DISPLAY_CATEGORIES_PER_ROW-1){

$col=0;

}else{

$col++;

}

}	



// needed for the new products module shown below
$new_products_category_id = $current_category_id;

?>





			</table>



<?  tep_draw_heading_bottom_1();?>				

<? tep_draw_heading_bottom();?>



<table cellpadding="0" cellspacing="0"><tr><td height="1"></td></tr></table>



<? tep_draw_heading_top();?>



<? new contentBoxHeading_WHATS_NEW($info_box_contents, true, false);?>



<? tep_draw_heading_top_1();?>			



		<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>



<? tep_draw_heading_bottom_1();?>



<? tep_draw_heading_bottom();?>	







</td>



<?php

 } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

					 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

					 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

					 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

					 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

					 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

					 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

					 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);



asort($define_list);



$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

  if ($value > 0) $column_list[] = $key;

}



$select_column_list = '';



for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

  switch ($column_list[$i]) {

	case 'PRODUCT_LIST_MODEL':

	  $select_column_list .= 'p.products_model, ';

	  break;

	case 'PRODUCT_LIST_NAME':

	  $select_column_list .= 'pd.products_name, ';

	  break;

	case 'PRODUCT_LIST_MANUFACTURER':

	  $select_column_list .= 'm.manufacturers_name, ';

	  break;

	case 'PRODUCT_LIST_QUANTITY':

	  $select_column_list .= 'p.products_quantity, ';

	  break;

	case 'PRODUCT_LIST_IMAGE':

	  $select_column_list .= 'p.products_image, ';

	  break;

	case 'PRODUCT_LIST_WEIGHT':

	  $select_column_list .= 'p.products_weight, ';

	  break;

  }

}



// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

  } else {

// We show them all

	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

  }

} else {

// show the products in a given categorie

  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

  } else {

// We show them all

	$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

  }

}



if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

  for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

	if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

	  $HTTP_GET_VARS['sort'] = $i+1 . 'a';

	  $listing_sql .= " order by pd.products_name";

	  break;

	}

  }

} else {

  $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

  $sort_order = substr($HTTP_GET_VARS['sort'], 1);

  $listing_sql .= ' order by ';

  switch ($column_list[$sort_col-1]) {

	case 'PRODUCT_LIST_MODEL':

	  $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	  break;

	case 'PRODUCT_LIST_NAME':

	  $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

	  break;

	case 'PRODUCT_LIST_MANUFACTURER':

	  $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	  break;

	case 'PRODUCT_LIST_QUANTITY':

	  $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	  break;

	case 'PRODUCT_LIST_IMAGE':

	  $listing_sql .= "pd.products_name";

	  break;

	case 'PRODUCT_LIST_WEIGHT':

	  $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	  break;

	case 'PRODUCT_LIST_PRICE':

	  $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

	  break;

  }

}

?>

<td width="100%" valign="top">







<? tep_draw_heading_top();?>	  







		  <table border="0" cellspacing="0" cellpadding="0" align="center" class="box_width_cont">

				  <tr>

<?php

// optional Product List Filter

 /*  if (PRODUCT_LIST_FILTER > 0) {

  if (isset($HTTP_GET_VARS['manufacturers_id'])) {

	$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

  } else {

	$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

  }

  $filterlist_query = tep_db_query($filterlist_sql);

  if (tep_db_num_rows($filterlist_query) > 1) {

	echo '			<td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

	if (isset($HTTP_GET_VARS['manufacturers_id'])) {

	  echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

	  $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

	} else {

	  echo tep_draw_hidden_field('cPath', $cPath);

	  $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

	}

	echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

	while ($filterlist = tep_db_fetch_array($filterlist_query)) {

	  $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

	}

	echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

	echo '</form></td>' . "\n";

  }

}*/



// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

  $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

  $image = tep_db_fetch_array($image);

  $image = $image['manufacturers_image'];

} elseif ($current_category_id) {

  $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

  $image = tep_db_fetch_array($image);

  $image = $image['categories_image'];

  $name = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "'");

  $name = tep_db_fetch_array($name);

  $name = $name['categories_name'];

}

?>



				</tr>

			</table>

			<table border="0" cellspacing="0" cellpadding="0" align="center" class="box_width_cont">

				<tr><td align="center" valign="top"><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td></tr>

			</table>



<? tep_draw_heading_bottom_1(); ?>



<? tep_draw_heading_bottom(); ?>



	</td>



<?php

 } else { // default page

?>

<td width="100%" valign="top">

<?php require(DIR_WS_BOXES . 'panel_top.php'); ?>



<? tep_draw_heading_top();?>



<? new contentBoxHeading_ProdNew($info_box_contents);?>



<? tep_draw_heading_top_1();?>





				<table border="0" cellspacing="0" cellpadding="0" align="center" class="box_width_cont">

					<tr><td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td></tr>

							<?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);?>

				</table>



<? tep_draw_heading_bottom_1();?>



<? tep_draw_heading_bottom();?>



</td>

<?php

 }

?>

<!-- body_text_eof //-->

<td valign="top">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</td>

 </tr>

</table>

<!-- body_eof //-->



<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

if some one can point out wht to do!

thanks

outside links are not allowed in signatures

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...