Group by and where?

Question

I'm trying to calculate some columns in a mysql database with this code:

"SELECT SUM(klick) FROM svar GROUP BY pollid HAVING pollID="& rstPoll("PollId")

But it doesn't work. So what I want to do is to get the sum of all "klick" where a pollId has a certain value. I got this code to work with access but not with mysql:

"SELECT SUM(klick) FROM svar WHERE pollID="& rstPoll("PollId"))

Some lines in the database: id: 180 klick: 10 pollid: 56

id: 181 klick: 53 pollid: 56

id: 182 klick: 10 pollid: 56

Now I want the sum of all the klick where pollId = 56 for example. So the results here would be: 73

Answer 1

to just get the sum of klick for a particular pollID you don’t need a group by clause:

SELECT SUM(klick)
  FROM svar
 WHERE pollID = %d

Answer 2

I don't know what this rstPoll() business is but this is entirely valid MySQL SQL:

SELECT SUM(klick) FROM svar WHERE pollID = 1234

assuming pollID is a numeric type. And it will do what you expect so you've got something else going on.

Answer 3

Your second query is correct. You must have a problem comparing two different types: pollID and whatever rstPoll("PollId") returns.