PDA

View Full Version : Show a specific record from a database


jvr06
11-20-2011, 01:30 PM
Hello, I seem to not get exactly what I need to do to make the following happen. I'm using Dreamweaver CS5, php & mysql.

I've created my website and I have a signup/login page that takes you to a restricted page. There's an account page that shows the users details but it only shows the first record of the database rather than the user that is logged in.

How do I display the logged in users details on the account page? If you can help, please provide a step by step as I can't seem to figure this out. It's been weeks!

Also, after a user logs in, which they will use their email address, how do I get to display their first name in the database rather than their email address as a greeting? I'm thinking this very similar to my first question.

Thanks in advance for any help someone can provide!

edbr
11-21-2011, 03:26 AM
you will have to add a where clause to the select query