View Single Post
  #2  
Old 03-28-2016, 03:58 PM
  DrQuietus's Avatar 
DrQuietus DrQuietus is offline
 

Advanced Member
  
Join Date: Dec 2005
Posts: 81
 

Default Re: How to add extra field values to the product list page

I am getting a sql error, can you tell why?

Quote:
SQL query : SELECT value FROM WHERE productid='24' AND fieldid='16' LIMIT 1
Error code : 1064
Description : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE productid='24' AND fieldid='16' LIMIT 1' at line 1

Quote:
$products[$c]['WHEEL_MATERIAL'] = func_query_first_cell("SELECT value FROM $sql_tbl[xcart_extra_field_values] WHERE productid='$v[productid]' AND fieldid='16'");
__________________
Dave Jones
dave@industrialwebworks.net
Mostly 4.7.2 - 4.7.5
Reply With Quote