I keep getting the following error:
Quote:
INVALID SQL: 1064 : 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 'AND fieldid= 2' at line 1
SQL QUERY FAILURE: SELECT value FROM xcart_extra_field_values WHERE productid = AND fieldid= 2
|
I'm probably not doing something right in the display code. (I just arbitrarily used the number 2 as the field I wanted displayed.)
Code:
{assign var="shirtcolors" value=$products[product].productid|extrafield:2} {if $shirtcolors ne ""}
Shirt Colors : {$shirtcolors} {/if}
Thanks,
Chris
Version 4.0.18