• Resolved Omaha303

    (@omaha303)


    I have a table with a column labeled Price, which is the one used for sorting. I use int(11) and the numbers are sort properly but I need to add a thousand separator. How can I achieve this?

    Also, when the field is left empty it automatically populate it with a zero. How can I stop this?

    All i need is my data be presented in such way like this

    [row 1] (empty space)
    [row 2] (empty space)
    [row 3] 10,000
    [row 4] 18,000
    [row 5] 23,500
    [row 6] 119,000
    [row 7] 200,000

    Thanks

Viewing 1 replies (of 1 total)
  • Plugin Author Stefan M.

    (@stefan-m-1)

    That you can add separator will not be possible via the plugin at the moment. In version 2.0 will come support for PHP code.

    <?=number_format({price},0,",",""'")?>

    Would do it then…

    The Zero can be filtered with the IF Smarttag:

    [IF field="{price}" check="!=" var="0"][/IF]

    Will output nothing if it is 0.

    Version 2.0 will be a major release and I working daily on it, but there are many features and bugfixes included.

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: custom tables] Data sorting’ is closed to new replies.