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?

Hello Duncan,
What are you sorting exactly and how?

Hi Teodor,

It's the ID column on this page. decimal.co.nz/extrack/app/view-all.php

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.

Thanks,

Hm, the ID is returned as string from your database.
What version of PHP are you using and what mysql server version?

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.

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.

Thanks Teodor. I've uploaded the file.

Thanks, i see you are running the latest PHP version. Do you see any option to update mysql from 5.6 to 5.7?

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.