SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Non-Member
    Join Date
    Feb 2006
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    *HOW TO? Find duplicate Row and ECHO it to page?

    Alright, I have a coded member system im using that needs one more thing,
    how can i have a mysql query search in the row "ip" for all members, to find duplicated IP's ( two dif. members with the same IP ) and ECHO it / show which members/their ip?

    It should be easy, please help me asap, thanks!

  2. #2
    Who turned the lights out !! Mandes's Avatar
    Join Date
    May 2005
    Location
    S.W. France
    Posts
    2,496
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Try

    SELECT ip FROM table WHERE COUNT(ip)>1 GROUP BY ip
    A Little Knowledge Is A Very Dangerous Thing.......
    That Makes Me A Lethal Weapon !!!!!!!!

    Contract PHP Programming


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •