MySQL Query Order

Question

$SQL->query('SELECT `p`.`name` AS  `name`,
  (SELECT `k`.`value` FROM `player_storage` k WHERE `k`.`key` = 1000  AND `k`.`player_id` = `p`.`id`) AS value
    FROM `player_storage` k, `players` p WHERE `k`.`player_id` = `p`.`id` GROUP BY  `name` ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 0 , 30;

PLAYERS

id | name   
1    test

PLAYER_STORAGE

player_id | key | value 
1          1000   10

The query works fine the only is problem that the order is not correct, idk why.

Example:

You are selecting two columns and output has only one column. Check your example — Abhishek
– Abhishek, Commented Feb 9, 2016 at 5:40
1. Why do not use a join instead of a subselect? 2. Are you sure that cast(value as signed) returns the value you expect and not just a bunch of zeros? — Shadow
– Shadow, Commented Feb 9, 2016 at 5:46
Another thing is there is a query, issued from php, and then there's this sort of html table rendering or whatever. Isn't there some intermediary post-processing stuff happening? — Sebas
– Sebas, Commented Feb 9, 2016 at 5:48
1. Because i dont know what i'm doing, i have no knowledge in queries and i got this result just doing tests... the only problem is the order. 2. Yes, the original query works fine with cast(value as signed) — dohdle
– dohdle, Commented Feb 9, 2016 at 5:51

JKrunD · Accepted Answer · 2016-02-09 05:57:20Z

1

Your example will return two columns, you're only ordering the second column.

edited Feb 9, 2016 at 5:57

answered Feb 9, 2016 at 5:48

JKrunD

465 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Query Order

PLAYERS

PLAYER_STORAGE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

PLAYERS

PLAYER_STORAGE

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related