Hey,
I want to on a page have it display the list of users with more then one account by ip address.
I know this isnt hard but nothing i have tried works.
If anyone can help
Thanks
searching for users with same ip
Moderator: General Moderators
- andyhoneycutt
- Forum Contributor
- Posts: 468
- Joined: Wed Aug 27, 2008 10:02 am
- Location: Idaho Falls
Re: searching for users with same ip
Could you be a little more specific? Are the users' IP Addresses stored somewhere? Are you just trying to find the IPs of all concurrent sessions? Not really sure what you're asking...
Re: searching for users with same ip
the ip address is stored in a members table.
Re: searching for users with same ip
This is a sql query:
SELECT COUNT(*), ip_address FROM members
GROUP BY ip_address
HAVING COUNT(*) > 1
This will give you all the ip_addresses that have multiple members. Obviously the column and table names could be different.
SELECT COUNT(*), ip_address FROM members
GROUP BY ip_address
HAVING COUNT(*) > 1
This will give you all the ip_addresses that have multiple members. Obviously the column and table names could be different.