DMXzone App Connect Support Product Page
28 Sep 2018 07:56:00
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?
28 Sep 2018 07:57:16
28 Sep 2018 07:57:16 Teodor Kuduschiev replied:
What are you sorting exactly and how?
28 Sep 2018 08:21:16
28 Sep 2018 08:21:16 Duncan Brooking replied:
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.
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?
28 Sep 2018 09:02:32
28 Sep 2018 09:02:32 Duncan Brooking replied:
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.
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.
28 Sep 2018 11:51:35
28 Sep 2018 11:51:35 Duncan Brooking replied:
Thanks Teodor. I've uploaded the file.
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?
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.
Reply to this topic Login to Reply