Title: [Plugin: custom tables] Data sorting
Last modified: August 20, 2016

---

# [Plugin: custom tables] Data sorting

 *  Resolved [Omaha303](https://wordpress.org/support/users/omaha303/)
 * (@omaha303)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-custom-tables-data-sorting/)
 * 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.](https://wordpress.org/support/users/stefan-m-1/)
 * (@stefan-m-1)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-custom-tables-data-sorting/#post-2284246)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-tables.svg)
 * [custom tables](https://wordpress.org/plugins/custom-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-tables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Stefan M.](https://wordpress.org/support/users/stefan-m-1/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/plugin-custom-tables-data-sorting/#post-2284246)
 * Status: resolved