I have this working fine but I want something a little extra and I can't seem to get it to work.
In the administration I want to be able to see the extra field in the product list.
The file to modify is main/products.tpl
I have tried
Code:
{$products[product].descr|truncate:300:"...":true}{assign var="itunes" value=$products[product].productid|extrafield:5} {if $itunes ne ""}{$itunes} {/if}
but i get this error
Code:
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= 5' at line 1
SQL QUERY FAILURE: SELECT value FROM xcart_extra_field_values WHERE productid = AND fieldid= 5
Does anyone have any suggestions?