X-Cart forums

[skipmartin]

I am displaying data from a table and I am unable to modify the column names. The problem is that one of the column names has brackets in it, for example 'ccost[0]'

When I try to display the value of that column using {$product.proddata.ccost[0]} smarty thinks I am trying to display a value of an array 'ccost'

Is there any way to trick smarty into using 'ccost[0]' as the actual fieldname and not a reference to an array?

Thanks,
Andy

[geckoday]

I would change the query to rename the field on retrieval. e.g.

SELECT ...,`ccost[0]` AS ccost0, ... FROM ....

Then you can refer to it as {$product.proddata.ccost0}

Another option might be:

{assign var='ccost0' value='ccost[0]'}
{$product.proddata.$ccost0}

[skipmartin]

Thanks - the assign var solution worked perfectly.