X-Cart forums - View Single Post - How to add extra field values to the product list page

DrQuietus · #4 03-28-2016, 04:22 PM

I've tried all of the below, same syntax error message, same line. Verified it is fieldid 16.

Code:

$products[$c]['Wheel Material'] = func_query_first_cell("SELECT value FROM $sql_tbl[extra_field_values] WHERE productid='$v[productid]' AND fieldid='16'");

Code:

$products[$c]['Wheel Material'] = func_query_first_cell("SELECT value FROM $sql_tbl[xcart_extra_field_values] WHERE productid='$v[productid]' AND fieldid='16'");

Code:

$products[$c]['WHEEL_MATERIAL'] = func_query_first_cell("SELECT value FROM $sql_tbl[extra_field_values] WHERE productid='$v[productid]' AND fieldid='16'");

Code:

$products[$c]['WHEEL_MATERIAL'] = func_query_first_cell("SELECT value FROM $sql_tbl[xcart_extra_field_values] WHERE productid='$v[productid]' AND fieldid='16'");