SQL Group BY error

[houssam_ballout]

hello all,

I am trying this sql:

select count(OptionNb),comments from tblanswer where idQuestion = $idQuestion And OptionNb = 'option$i'

and I got this error

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

 

How could I solve it ?

Thanks in advance

[uniflare]

you may want to review: http://dev.mysql.com/doc/refman/5.0/en/counting-rows.html

 

 

im not sure what exact reslults your trying to get and what your table structure is but you could try this:

 

select count(OptionNb),comments from tblanswer where idQuestion = $idQuestion And OptionNb = 'option$i'  GROUP BY `comments`

[aschk]

I'm curious to know what information you're trying to get out of this.

On 1st inspection I thought you were after the number of comments for a particular question, however I then realised you appear to be after something related to OptionNB. What is OptionNB?

 

The query that uniflare has given you will count the number of options based on comment, where the question id is set and the OptionNB is set.

 

Clarify what you're expecting from this query and i'm sure we can guide you in the right direction.