My website will be running a contest soon and I need some help setting up a script that will catch cheaters. I will be selecting two tables which contain member name, and IP address. I want the script to display IP addresses that are in the table more than once and the member names for each ip address used more than once. Where do I start?
An easy way to point out the duplicates is to use the GROUP BY and the HAVING abilities of sql.
select ipaddress, count() from myTable group by ipaddress having count() > 1;
This will show you all ip address in the table more than once.
