turnej Posted April 18, 2011 Share Posted April 18, 2011 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 Quote Link to comment https://forums.phpfreaks.com/topic/234104-db-queries/ Share on other sites More sharing options...
The Little Guy Posted April 19, 2011 Share Posted April 19, 2011 This is a really great example: http://phpsnips.com/snippet.php?id=4 Quote Link to comment https://forums.phpfreaks.com/topic/234104-db-queries/#findComment-1203299 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.