Does order by work with minus numbers because i wanna sort this range.

Points: 3 Goal Difference: 1
Points: 0 Goal Difference: - 1
Points: 3 Goal Difference: 4
Points: 0 Goal Difference: -4

I am sorting my points desc first and then goal difference.
Mysql Query:

PHP Code:

$sql = mysql_query("SELECT * FROM `manager__tables` WHERE `league` = '" . $league['name'] . "' ORDER BY `goal_difference` DESC, `points` DESC"); 


The range should look like this:

Points: 3 Goal Difference: 4
Points: 3 Goal Difference: 1
Points: 0 Goal Difference: -1
Points: 0 Goal Difference: -4

But it looks like This


Points: 3 Goal Difference: 4
Points: 3 Goal Difference: 1
Points: 0 Goal Difference: -4
Points: 0 Goal Difference: -1

Also When Trying to rank the numbers 1 - 20 its goes like this:

1
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9

Goal difference and points are always going to be numbers.

Your quoting them so they become strings - remove your quotes and you should be one your way.

Originally Posted by evans123

Also When Trying to rank the numbers 1 - 20 its goes like this:

1
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9

I think this is basically because MYSQL count funny lol.

you can probably do it with php or a workarround.

I think this is basically because MYSQL count funny lol.

Only if the numbers are actually strings (as maxxximus pointed out)

I am having a similar problem. I am trying to grab the contents of the field bid out of the table and order desc but it doesn't seem to work. Here is my code for the query:

"SELECT * FROM Links ORDER BY bid DESC LIMIT 10"

There are 3 things and the order comes out:
43
32
138

If I change it to ASC it outcomes:
138
32
43

The only thing I can think of is that before I add to the DB I round it from 138.00 to just 138, but that still doesnt really make sense. Anyone?

Originally Posted by J0ker

I am having a similar problem. I am trying to grab the contents of the field bid out of the table and order desc but it doesn't seem to work. Here is my code for the query:



There are 3 things and the order comes out:
43
32
138

If I change it to ASC it outcomes:
138
32
43

The only thing I can think of is that before I add to the DB I round it from 138.00 to just 138, but that still doesnt really make sense. Anyone?

Your Links field is a string data type such as varchar. Your data type needs to be int or float.

As both maxxximus and joder pointed out, you save your numbers as strings. When comparing strings, lets say 'a' and 'b', which one somes first? 'a', right. When comparing 'aaaaaaaaaa' with 'bbb', which one comes first? Right, 'aaaaaaaaaa'. And so 'azzzzz' comes before 'zaa'.

Now lets compare '40' to '1073'. As a human you understand that 40 is smaller than 1073 and should come first, but since it's a string, and '1' comes before '4', that means '1073' comes before '40'.

i know its because of it being a string but can someone tell me a logical reason why the programmers didnt think hey lets tell it how to count if the numbers a string too?

Number is a number, string is a string. They are used for different purposes. Strings are compared different than numbers. To compare strings as numbers you should cast them to numbers first. If you try to compare strings as strings and receive not what you expected don't blame programmers, in this case the only stupid person is you.

Because nobody knows what you really expect to get when you make if ($string == $another_string), that's why type casting was invented.

i have got same problem, it work now perfectly .(Strings are compared different than numbers.( 1234..) To compare strings as numbers you should cast them to numbers first.)

Originally Posted by mtishetsky

Number is a number, string is a string. They are used for different purposes. Strings are compared different than numbers. To compare strings as numbers you should cast them to numbers first. If you try to compare strings as strings and receive not what you expected don't blame programmers, in this case the only stupid person is you.

Thanks for that i was just wondering why they didnt just make it the same if the string was alll numbers...

so while you have both said it anyone want to tell me and everyone how to convert a string to number?

Thank you! This was totally killing me!

Originally Posted by dansgalaxy

Thanks for that i was just wondering why they didnt just make it the same if the string was alll numbers...

so while you have both said it anyone want to tell me and everyone how to convert a string to number?

http://www.php.net/intval

and in SQL

... CONVERT('456',unsigned) as converted ...

I usually use (int)$var