Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by cidrolin

  1. cidrolin

    Customers extra fields

    Yeah, great contibution ! if I understand correctly, this is this code wich displays the extra fields in product_info : // START: Extra Fields Contribution v2.0b $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 would like to re-use it in another file (for exemple in product_news, below the name and model of product) : but there is something I don't understand, because I'm unable to do this. Everywhere I put the code, even in a blank file( with <html><head>... and so on), Firefox complains (syntax error :blink: ) Am I missing something ? Any help will be greatly apreciated, even a clue :D !