SELECT problem

[derrtyones]

I got a tablename called portfolio. It contains some general information of users like id, loginname, password, firstname, lastname, age, location. I need a PHP script that reads and displays the information of the user that's logged in. So I think the easiest way out would be something like selecting everything where the loginname is the same as the sessionname. How do I do this?

[Mchl]

How do I do this?

 

That's pretty general question. Do you have any PHP code already? Do you need help with creating SQL query?

[JasonLewis]

Yeah just think about it. Write down some logical steps that you should take.

 

First you would need the person to login and set the session of their name (which it sounds like you've done).

 

Second you need to query the database and retrieve this information using a function such as mysql_fetch_assoc().

 

Third you would just need to display the information to the user.

 

Really you just need to think about things logically. If you have trouble then write down the steps. If you need more help, Google is a very good friend to have.