Form a query

[orion_rus]

Hello i have 3 fields
1 id
2 askword
3 ip

askwords and ip isn't unique - some ip can askword many times
i need a following select -> find how much askword was asked from different ip
if i make only group by askword with add field askwordcount COUNT(askword) i have not exactly what i want because it also counts a askword from ip if it has 2 or more fields in a database.
i hope i'm clear. Anybody can help me?
Thanks in advance

[aspdaddy]

You should have made askword and IP a composite key. You might be able to workaround it using DISTINCT Askword.