Help with a query

[dgprado]

I heave a question.
I will try to explain.

Ex:

Player_storage table.

player_id     key    value
    1          1      10
    2          10     100
    3          6      20
    4          10     60
    5          10     30
    6          10     80
    7          5      70
    8          10     40
    9          10     90 
   10          3      40

There is some query to select the 3 players who heave the highers "values" and "key" = 10 ?

 

[Jano]

select player_id from player_storages where key = 10 order by value desc limit 3 (?)

 

[dgprado]

select player_id from player_storage where 'key' = 1354 order by 'value' desc limit 3

MySQL retornou um conjunto vazio (ex. zero registros). ( Consulta levou 0.0004 segundos )


I won make a experiance ranks page for pet system made by josejunior and i need this query,

Thx for atention

 

[Zisly]

'SELECT player_id FROM `Player_storage` WHERE key=10 ORDER BY value DESC LIMIT 3;'

Should work.

 

[dgprado]

Thx but not work

still no match

 

[Jano]

then you are wrong with the key.

 

[dgprado]

Mostrando registros 0 - 29 (1,114 total, Consulta levou 0.1588 segundos)
SELECT *
FROM `player_storage`
WHERE `key` =1354
LIMIT 0 , 30

 	                    player_id 	key      value
	Editar 	Remover 	3 	1354 	315120507
	Editar 	Remover 	4 	1354 	0
	Editar 	Remover 	141 	1354 	0
	Editar 	Remover 	222 	1354 	0
	Editar 	Remover 	399 	1354 	0
	Editar 	Remover 	746 	1354 	0
	Editar 	Remover 	801 	1354 	0
	Editar 	Remover 	978 	1354 	0
	Editar 	Remover 	1227 	1354 	0
	Editar 	Remover 	1333 	1354 	0

no i dont the key is 1254 and heave 1k+ of entries

 

[Zisly]

I don't get what you're saying.. what is the problem now?

 

[dgprado]

then you are wrong with the key.

I am saying that i am not wrong with the key, but when i execute that query mysql return 0 results.

 

[Jano]

SELECT player_storage.player_id FROM player_storage WHERE player_storage.key = .... ORDER BY player_storage.value DESC LIMIT 3

just remember "key" its a reserved string :x i forgot it.

 

[dgprado]

Hum we are geting closer
I made some changes to get names from players table but now the query isant ordering by the value roll, its making alfabetic order by the names ;x

SELECT players.name FROM players where players.id in (select player_id FROM player_storage WHERE player_storage.key = 1354) ORDER BY "value" DESC LIMIT 3