[SOLVED] Count doesn't work properly

[Minase]

i have this query :|

 

SELECT * FROM `items` WHERE `ID` IN  (85,117,156,216)

 

i tried

SELECT *,COUNT(Strenght) FROM `items` WHERE `ID` IN  (85,117,156,216)

 

but it returns just the first row,with no count :|

[cags]

a.) is the column actually called Strenght (as opposed to strength).

b.) do you really want to select everything and the count.

c.) when you say it just returns the first row with no count, what code are you using to access it.

[Minase]

yes i use strenght instead of strength

and again my bad i used count instead of SUM :|

today it's not my best day =/ sorry for opening so much topics -.-

thx for help