db queries

[turnej]

Hi

 

I am very new to php and mysql but have managed to set up a password protected page for members only, with this in mind I have a mysql table called members which has all the usernames and passwords of my members, from this table I need to display the username of the person that is logged in, so for example if someone logs in with a username called John, my page will say hello John.

 

I then have an input form where my members can add the names of people they want adding to a list on my second table called guestlist, I would like to find a way that when they add a name to the guestlist it automatically adds their name to the table, i.e. name - Joe Bloggs - added by user xyz

 

I then want to display all the fields from the guestlist table in a table format all the fields from this table, for example Name, Surname, added by etc.

 

As I said I am very new so I apologise in advance as to how simple some people will find this query and also ask that any help is aimed at a newbie ha

[The Little Guy]

This is a really great example:

 

http://phpsnips.com/snippet.php?id=4