[lukey]

I have set up a mysql database with 'username', 'password', 'group name' and 'colour' fields.

I have inserted username, password and group names of users into the database. (username and password will be given to them, the groupnames are also pre-entered into db)

I have tested it and the login script is working via the form on mywebsite.

The mysql database looks like this:

username    password    group name        colour
clown	    admin       smarties          (selected via form to store in database)
clown	    admin       inbetweeners      "
fun         school      colourking        "
fun         school      underdogs

The next step I want it to do is once the a user logs in with their username and password I would like their group name to automatically be displayed in a textfield. I then want them to select their colour and the colour is then stored in the database.
So if i logged in as username 'clown' and password 'admin' the group names would be displayed in 2 columns and after each group name they can then select their colour from a drop down. Once submitted it stores into the database.

My question are as follows

Is this a simple enough task?
are there any examples/tutorials of the php script on the internet that would help me?

Thanks in advance