SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2000
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just to let you all know, I'm a beginner at PHP and MySQL...

    anyways, I figured out how to insert member signup info(username, password, email, address, etc..) into my table MEMBER_LIST. However, I want to make sure that there is no duplicate members, that someone doesn't signup twice. I'm limiting the duplication check to username, email, and first name + last name(together). My question is how do I program this? just the duplication check?

    let me know if I can clear anything up further, thanks,
    kankohi

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Well, you can create your table in MySQL so that the columns in question cannot contain duplicate values. See this thread for an example of how this is done, and let us know if you have any questions!



    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!


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
  •