What's new

Zapytanie do bazy ? HELP!

Status
Not open for further replies.

Kilogram

Active User
Joined
Oct 12, 2009
Messages
75
Reaction score
0
Witam potrzebuje zapytania do bazy danych ?eby pokaza?o mi kto ma najwi?cej itm w depo ! Prosze pomocy; >
Help Pomocy baza mysql !
Notka moderatorska:
Raz nie da?em ostrze?enia za post pod postem, ale jak mo?na dalej pisa? tak samo to ja nie rozumie
 

piti129

Advanced User
Joined
Apr 4, 2008
Messages
242
Reaction score
39
Odp: Zapytanie do bazy ? HELP!

Na szybkosci mozesz sprawdzic to tak :D
PHP:
SELECT COUNT(*), player_id
FROM  player_depotitems GROUP BY player_id
 

Kilogram

Active User
Joined
Oct 12, 2009
Messages
75
Reaction score
0
Odp: Zapytanie do bazy ? HELP!

mhm ale to wy?wietli mi kto ma najwiecej itms w depo : >
 

Reverse

Advanced User
Joined
Jul 11, 2010
Messages
191
Reaction score
46
Odp: Zapytanie do bazy ? HELP!

No o to Ci chyba chodzi?o, nie ?
 

piti129

Advanced User
Joined
Apr 4, 2008
Messages
242
Reaction score
39
Odp: Zapytanie do bazy ? HELP!

No a jakie pytanie bylo??:D
 

Kilogram

Active User
Joined
Oct 12, 2009
Messages
75
Reaction score
0
Odp: Zapytanie do bazy ? HELP!

no bo u mnie na ots laguja znanym sposobem duzo itms w depo i relog .
I chce si? dowiedzie? kto ma du?o itm?w w depo .?
 

Kowol

Senior User
Joined
Apr 9, 2008
Messages
1,250
Reaction score
158
Odp: Zapytanie do bazy ? HELP!

Code:
SELECT player_id, count(*) FROM `player_depotitems` GROUP BY player_id ORDER BY count(*) DESC
 

piti129

Advanced User
Joined
Apr 4, 2008
Messages
242
Reaction score
39
Odp: Zapytanie do bazy ? HELP!

Code:
SELECT player_id, count(*) FROM `player_depotitems` GROUP BY player_id ORDER BY count(*) DESC
Jak jest :D idiota i nie potrafi sobie wcisnac rosnaca.. To wiadomo jeszce moze chce jedna osobe zeby mu pokazalo tylko...

Code:
SELECT COUNT( * ) , player_id
FROM player_depotitems
GROUP BY player_id
ORDER BY COUNT( * ) DESC 
LIMIT 1
 
Status
Not open for further replies.
Top