Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Jan 2006
    Posts
    377
    Thanks
    8
    Thanked 1 Time in 1 Post

    (1stName+Surname) or Fullname

    Hi,

    I know it is a matter of personal preferences but I need your experience on this one. I do a lot of sites where I keep visitors identity as name and surname in seperate MySQL columns. I don't know why but I simply started like this. Naturally, the signup form also contains to seperate fields like name and surname.

    I am thinking of gathering this info in a single (fullname) field and store it in a single DB field.

    I would like to listen to your experiences, does seperating these two names help the admin in any way? Keeping the name and surname seperate from each other, will this bring advantages to me some day?

  • #2
    New to the CF scene
    Join Date
    Dec 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    For myself, it depends on the application I have designed. I am working on an Intranet system right now so I have a separate field for first, middle and last name. It makes life easier on me for sorting names.

    I do, however, create a fourth field called display_name. In my company, there are some picky people who don't like their real name. An example being someone named Susan who only likes to be called Sue. So when she communicates with other users, they only see her display_name but people such as the HR department can see her real info if desired.

  • #3
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    I would go with a separate field for each name. I feel that you should always try to preserve as much info as possible. If you have their first and last names, why merge them together and lose the extra flexibility?

    Dan
    PHP Tip: If you want to use short tags (<? or <?=$var) then make sure short_open_tag is set to "1". It really helps.

    Don't forget to save everyone time and mark your thread as Resolved :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #4
    Regular Coder
    Join Date
    Jan 2006
    Posts
    377
    Thanks
    8
    Thanked 1 Time in 1 Post
    Thanks guys, right, the display_name idea is very useful to me, thanks!

  • #5
    New Coder
    Join Date
    Nov 2006
    Location
    UK
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That's how I would do it!

    Have a first, middle and last name fields, plus a display name field.
    - Mark


  •  

    Posting Permissions

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