[Resolved] ORDER listing

[fean0r]

$query_items = "SELECT * FROM top10 ORDER BY dls DESC";
$items = mysql_query($query_items) or die(mysql_error());
$row_items = mysql_fetch_assoc($items);

I've set up 10 dummy entries (10 - 1)

But it does nt work correctly - I get

addon 2
addon 3
addon 4
addon 5
addon 6
addon 7
addon 8
addon 9
addon 1
addon 10

dls = digits only 1 - 10

any ideas why when I list them they dont list correctly?

[Buddha443556]

Try something like:

$query_items = "SELECT * FROM top10 ORDER BY total(dls) DESC"; 

Have no I idea if that will work but might give you an idea.

[fean0r]

thanks for the idea but it did nt work 🙁

[fean0r]

If you are trying to sort a field of numbers and you find it coming out like this: 1 10 11 12 2 3 4 the reason is that the field type is not of the INT variety, therefore it is ordering the information as though it were a string. A quick fix for this (though it is probably best to change the field type to INT) is to force MySQL to treat the string as a number by putting 0+ infront of the field name in the ORDER BY clause. ie: SELECT month FROM searchlog ORDER BY 0+month; I hope this helps! P.S. That is a zero not a capital 'o'.

Found my problem, the code is fine its the mysql it was varchar instead of int.

[Buddha443556]

Actually MySQL doesn't have total() function, but I see you found a solution. I was probably thinking ABS() which still wouldn't have worked.