sorry, i messed up alittle bit at the product listing sql query, for product listing,
Erase this if you already install:
$product_query = tep_db_query("select products_description, shipping_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
$product = tep_db_fetch_array($product_query);
$new_products['products_description, shipping_description'] = $product['products_description, shipping_description'];
Find or replace the above with this:
$product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
$product = tep_db_fetch_array($product_query);
$new_products['products_description'] = $product['products_description'];
and add this below:
$product_query = tep_db_query("select shipping_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
$product = tep_db_fetch_array($product_query);
$shipping_description['shipping_description'] = $product['shipping_description'];
then use this: instead of the one in the instruction.
';
if(tep_not_null($shipping_description['shipping_description'])) echo ''; else echo ' Carrier information is not available.'; echo $shipping_description['shipping_description'];
echo '
More...





LinkBack URL
About LinkBacks









Bookmarks