query to variable question

[brokeDUstudent]

Hey how's it going,
I think this is pretty simple.. I'm not quite sure how to do it though. On my site, I have a section where users enter their username and password and in the script I want to be able to get the email address thats associated with that username/password.

I tried something like this..

$emailquery = mysql_query("SELECT email FROM users WHERE loginName = '$loginName' AND pword = '$pword'");

$email = mysql_result($emailquery);

... I thought that would be how I could get the email address into the variable $email but it didn't work, I received this error: Warning: Wrong parameter count for mysql_result()

Any ideas would be great, thanks for your help.

[Stoned_Gecko]

http://php.net/mysql

You should use mysql_fetch_row to get the return result. The manual explains how to do it rather well.

[brokeDUstudent]

That's awesome, it works perfect gecko..

I'm actually able to do a lot more with that now, I had no clue it was that easy..

Thanks for your help!

[Stoned_Gecko]

You're welcome. The PHP manual explains most of the stuff very clearly. That's how I learned PHP, so bookmark it 🙂