Script for individual user accounts

[nascarjunky]

Just in case it is not obvious when you read through this post I am a complete newbie and would be very grateful for any and all help.

I am running a nascar fantasy league website and would like to be able to perform the following.

 1) Require players to establish a user id and password
 2) Use this information to allow access to mysql database stored data.       
      In other words I want to create a members only area. The twist comes in
      here. I want each player to only be able to view his information. (This 
      includes things like fees, account balance, driver roster, trades, etc.) I 
      have searched through many user authentication ideas but none seem to
      apply to me.

I am looking for something that works similar to logging on to your credit card account online.

Again, any and all help is GREATLY appreciated.

Thanks

[Shaped]

Take a look back at the login/accoutn scripts that you have looked at.

then you can modify this so that the mysql_query only gets the data for that user.

SELECT * FROM USERS WHERE username = '' && password = '' LIMIT 1

this way it will only pull the information that applies to his/her account.

[nascarjunky]

In order to use this query will I have to establish the user name for each person myself. What I getting at is that I don't understand how this query could work if each person loads their own username and password. When I am loading records in the database I won't know what to assign as the username.

Again I am a newbie and I realize I am probably just missing something here.

Thanks