Must be simple...

[TF Solutions]

I have added "Products Extra Fields" contribution... It all seems to work fine, I can add fields, add content to those fields when editing products, preview the view etc...

 

BUT, the view through the shopfront doesn't display the info... I've made the following cahnge as per instructions to produc_info.php

 

<?php
   }

?>
         <p><?php echo stripslashes($product_info['products_description']); ?></p>
   <p><?php
// START: Extra Fields Contribution v2.0a
 $extra_fields_query = tep_db_query("
                     SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value
                     FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef
            LEFT JOIN  ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf
           ON ptf.products_extra_fields_id=pef.products_extra_fields_id
           WHERE ptf.products_id=".$HTTP_GET_VARS['products_id']." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".$languages_id."')
           ORDER BY products_extra_fields_order");

 while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
       echo '<b>'.$extra_fields['name'].': </b>';
       echo $extra_fields['value'].'<BR>'; 
 }
// END: Extra Fields Contribution
?></p>

 

I must be doing something wrong... any ideas?

 

Thanks! Tim