Selecting certain things from a database. Need help...

[ricerocket]

How can I do the following:

 

Theres a contact form which has two parts. the first part is for the public and the second is for members. The public section is fine and works how i need it but I need the member section to automatically get the name and email. The username is stored in a session but the email is stored in the database, how do I get the email from the database into a variable using the username which is in the session??? Help please I'm really lost...

[priti]

with a help of query you can fetch the email address of username

 

select email from user_table where username=$_SESSION['username'];

 

is this your problem??

[ricerocket]

Yea that exactly what I need but I don't know how to turn that into a variable... How would I do that? And also if I needed to select the password which is an md5 for a registration email how would I do that?

[priti]

i hope you are aware of mysql function availabel in PHP.....

 

$dbconnect=mysql_connect(username,password,host);

mysql_select_db("database name");

 

...

then use mysql_query() to execute the query and use mysql_fetch_row or mysql_fetch_array() to get the result in the php variables. regarding md5,md5 is one way encryption method. Hence you need to do md5("text value from form"); has to be used in your query

 

something like

select email from user_table where username=$_SESSION['username'] and password=md5($_POST['password']);