I try to make SQL from PHPmyadmin, and the result is 9 please see attachment below what is something wrong with my data?fahmisalim wrote:Hi sergey,
Please see my attachment, in field_191 I put data from number 1 to number 15 and in the other field I'm using a function Max to show highest value from field_191 and the highest value show number 9 not 15. Its should be 15
Function with MAX bugs
-
- Sponsor
- Posts: 320
- Joined: 12 May 2015, 08:33
- Name: Fahmi Salim
- Location: Indonesia BSD City
- Company Name: AIMan
- Contact:
Re: Function with MAX bugs
- support
- Site Admin
- Posts: 6216
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Function with MAX bugs
Which mysql type field 191 is used? TEXT or Varchar?
-
- Sponsor
- Posts: 320
- Joined: 12 May 2015, 08:33
- Name: Fahmi Salim
- Location: Indonesia BSD City
- Company Name: AIMan
- Contact:
Re: Function with MAX bugs
VARCHARsupport wrote:Which mysql type field 191 is used? TEXT or Varchar?
- support
- Site Admin
- Posts: 6216
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Function with MAX bugs
Ok, I think I have found issue. Replace attached file to plugins\ext\classes\
Let me know if it fixed.
Let me know if it fixed.
- Attachments
-
- functions.php
- (8.82 KiB) Downloaded 340 times
-
- Sponsor
- Posts: 320
- Joined: 12 May 2015, 08:33
- Name: Fahmi Salim
- Location: Indonesia BSD City
- Company Name: AIMan
- Contact:
Re: Function with MAX bugs
Yes its works!!
Thanks sergey
Thanks sergey