2. PHPRunner General questions
  3. [SOLVED]  How to set up field in table
This topic is locked
[SOLVED]

 How to set up field in table

 		7/12/2011 4:27:42 PM
PHPRunner General questions
F
 futo author

Good evening everyone...
How do I set a field in a table (MySQL), which is defined as a "double" with no decimal places after the comma.
In the visual editor I tuned the number of decimal places to zero. Size = 6 Max.lenght=6 When I write number 1236, and stores the data, write the number as 1.236
I have try set up field like decimal number... same thing is hapend. If i set up field like Varchar then is displayed ok, but i dont sort on list page in order
Thanks
C
 		cgphp 7/12/2011

Set the field as custom: http://xlinesoft.com/phprunner/docs/_view_as__settings_custom.htm Then add this code:

$value = number_format($value, 0, '', '');