First Login Script
View Single Post
02-13-2008, 10:50 PM
Join Date: Nov 2007
Originally Posted by
Can I ask what UserID is? Is it an auto number field given to each user?
Yes; in my table designs I will often use an AUTO_INCREMENT INT value as the PRIMARY KEY to link tables on. So each user has a `userID` field that is the most basic, simple method to refer to that user, regardless of how many columns and how much data is stored in them. Link it in the session data and the `logins` table if you are so inclined to add one. No need to store the username or any other data if you simply store the `userID`.
I reject your reality, and substitute my own.
The Following User Says Thank You to SOCK For This Useful Post:
View Public Profile
Send a private message to SOCK
Find More Posts by SOCK