Jump to content


Photo

count


  • Please log in to reply
No replies to this topic

#1 higgins

higgins
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationVienna, Austria

Posted 24 March 2003 - 01:37 PM

i\'m doing hard on a COUNT SELECT:

in a table STATS there are the following columns:

sid id wlt

\'sid\' is the key (integer value), \'id\' the player\'s number (integer value) and \'wlt\' describes if the player won, lost or tied a game (character either \'w\', \'l\' or \'t\').

the following entries are in the table STATS e.g:

sid_id_wlt

----------

04 79 t

11 31 w

16 31 w

18 31 w

21 31 w

30 31 w

35 31 w

37 31 w

39 79 t

43 31 w

49 31 w

56 79 w

74 31 w

83 85 l

99 85 t


i\'m trying to get counts/sums for the distinct players 31, 79 and 85 within one query, like:

id__w__l__t

------------

31 10 00 00

79 01 00 02

85 00 01 01


i use:
SELECT DISTINCT stats.id,IF(stats.wlt = \'W\', count(*), 0) AS W,IF(stats.wlt = \'L\', count(wlt), 0) AS L,IF(stats.wlt = \'T\', count(wlt), 0) AS T FROM stats group by stats.id, stats.wlt

but always i get something like this:

id__w__l__t

----------

85 00 00 01 

79 00 00 02 

85 00 01 00 

79 01 00 00 

31 10 00 00

anyone has a clue how to fix this prob? i\'d really appreciate it -
thanx higgins




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users