Intersect - SQL query help

[shakiel]

Hi friends

I'm stuck on how to write this query. I'm a noob so go easy on me:

SELECT `pollselection`, count( * ) votes
FROM info
GROUP BY `pollselection`
ORDER BY number DESC

Provides a count for how many times a poll selection was voted for. But I want to count only DISTINCT / unique ip addresses, not someone who voted twice. So I also have:

SELECT DISTINCT `ip`
FROM info

How do I combine the latter with the former?
Good day all -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[wilkinson]

If the poll offers choice A and choice B and you have the same IP address voting for both which one do you choose to count?

what if it was two different people using a computer at say a library so they would end up with the same IP. why would you reject one vote and not the other? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --