[SOLVED]  Sorting by number not working logically

This topic is locked

[SOLVED] Sorting by number not working logically	5/26/2011 4:56:23 PM
PHPRunner General questions
J JCJordan author On the initial pages of my app, it lists everything in the correct order going by id number, but if I sort by my inventory number (i.e. 1,2,3,...,10,11) the list turns into 1,10,11,...2,20,21 etc. How do I go about changing the sort to use absolute number instead of logical number?


	Sergey Kornilov admin 5/26/2011
	Make sure you are not storing numeric values in text fields. Values stored in text field will be sorted as text which is what happening.