Retriving Information from database

[Blekk]

Hi,

I have only really started php after a dabble in it about 2 years ago, this may seem rather basic but I am trying to retrieve an email address for a test user from a database.

This is my code:

[code]$resultEmailRetrival = mysql_query("SELECT emailaddress FROM te_users WHERE username='".mysql_real_escape_string($username)."'");[/code]

I then printed $resultEmailRetrival but it isn't the email address, do I have to do something like mysql_fetch_assoc or something?

Thanks,

Any reply is appreciated.

[Blekk]

No suggestions?

[jcbarr]

add this

[code]
$resultEmailRetrival = mysql_query("SELECT emailaddress FROM te_users WHERE username='".mysql_real_escape_string($username)."'");
$email=mysql_fetch_assoc['$resultEmailRetrival'];
echo $email;
[/code]

[Blekk]

Thanks jcbarr,

But when I use that, and print (or echo) $email, all it prints is:

[quote]Array[/quote]

Not the email address, does anyone know what is wrong?

Thanks,

[jcbarr]

lol...

Should be this
[code]
$resultEmailRetrival = mysql_query("SELECT emailaddress FROM te_users WHERE username='".mysql_real_escape_string($username)."'");
$info=mysql_fetch_assoc($resultEmailRetrival);
echo $info['emailaddress'];
[/code]

[Blekk]

Ah, maybe I should have looked into fetch_assoc, now I see it returns an array,

Thanks.