DMXzone App Connect Support Product Page

Number Sort

Asked 28 Sep 2018 07:56:00
has this question
28 Sep 2018 07:56:00 Duncan Brooking posted:
I'm trying to set up some sort buttons on a INT field and the sort isn't sorting naturally i.e. 1, 5, 10, 15 is sorting as 1, 10, 15, 5. Is there some sort of formatting I'm supposed to apply to get this sorting in numerical order?


Replied 28 Sep 2018 07:57:16
28 Sep 2018 07:57:16 Teodor Kuduschiev replied:
Hello Duncan,
What are you sorting exactly and how?
Replied 28 Sep 2018 08:21:16
28 Sep 2018 08:21:16 Duncan Brooking replied:
Hi Teodor,

It's the ID column on this page.

I've followed the App Connect/Data Traversal tutorial to get this far and the other columns sort correctly. This is a INT field in my database.

Replied 28 Sep 2018 08:36:02
28 Sep 2018 08:36:02 Teodor Kuduschiev replied:
Hm, the ID is returned as string from your database.
What version of PHP are you using and what mysql server version?
Replied 28 Sep 2018 09:02:32
28 Sep 2018 09:02:32 Duncan Brooking replied:
Good question...

PHPMyAdmin tells me that the Database Server version is 5.6.40. There is a section under that that says "Web Server PHP version: 5.6.30"

The hosting cPanel tells me the PHP version is set to 7.2. though.
Replied 28 Sep 2018 09:23:26
28 Sep 2018 09:23:26 Teodor Kuduschiev replied:
Could you please create an empty php file in your site root, call it info.php and add this inside:

<?php phpinfo() ?>

Send me the link to and i will check your config.
Replied 28 Sep 2018 11:51:35
28 Sep 2018 11:51:35 Duncan Brooking replied:
Thanks Teodor. I've uploaded the file.
Replied 28 Sep 2018 11:53:36
28 Sep 2018 11:53:36 Teodor Kuduschiev replied:
Thanks, i see you are running the latest PHP version. Do you see any option to update mysql from 5.6 to 5.7?
Replied 28 Sep 2018 13:33:55
28 Sep 2018 13:33:55 Duncan Brooking replied:
Not that I can see, it's a Hostpapa shared hosting account. Thanks for your help, I may just remove the sort buttons at this stage until I have more time to work on this. I may try and rebuild the database in case I did something wrong in the setup.

Thank you.

Reply to this topic