seventeen

make table user that contain user id and name then add another table score's field that contain user id...

select the user id with php (USER MUST LOG IN FIRST)
then INSERT user id into table score..

hope this will help

pedagog

Thanks for responding Seventeen

I understand what you mean, but if I have a table with the user, and the userID is say, 1, should I store the actual userID in the user table. Is it best to somehow encrypt the userID so that it is not visible in the user table?

I have read that it is best not to store userName, Passwords or UserIDs in a table when they are not encrypted. What do you think?

If I do need to encrypt them, how would I capture the userID if it is encrypted, so that I could use it to store the user’s score?

Sorry it’s a bit of a long response.

Thanks

Pedagog

seventeen

Store Username and password or userID in mysql table is OK, it will safe..

say it like this... u make user table contain UserID, username, password and userEncrypt..

then u insert the real userID, Username and password also userEncrypt but encrypt UserID first then Insert into userEncrypt field

Hope This May help....