Minase Posted October 23, 2009 Share Posted October 23, 2009 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 :| Quote Link to comment https://forums.phpfreaks.com/topic/178735-solved-count-doesnt-work-properly/ Share on other sites More sharing options...
cags Posted October 23, 2009 Share Posted October 23, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/178735-solved-count-doesnt-work-properly/#findComment-942847 Share on other sites More sharing options...
Minase Posted October 23, 2009 Author Share Posted October 23, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/178735-solved-count-doesnt-work-properly/#findComment-942852 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.