getting value from a database

[Vivid Lust]

Hi, with php, how do i get a value that i am trying to get, from a mysql database if the sql is:

 

SELECT email FROM members WHERE username = username

$email = 

 

thanks!

[akitchin]

you need to use some or all of the following functions:

 

mysql_connect

mysql_select_db

mysql_query

mysql_fetch_array

mysql_result

 

there are also a number of tutorials if you simply google the phrase "using mysql with php".

[Vivid Lust]

Do i still use mysql_fetch_array() in a while loop if i only want to get one value?

 

[akitchin]

no, there's no need - you can just assign the return value from mysql_fetch_array() to a variable. that will give you an array, so you'll need to specify the column as the array's index:

 

echo $variable['column_name'];