Date: 07/20/06 (PHP Community)    Keywords: mysql, sql

I have a question.

If I have a user enter their email at a login screen with their email and password, the following should work to match the password with the e-mail, correct?

$ema = $_POST['ema'];
$pw = mysql_query("SELECT password FROM users WHERE email = '$ema'");

I mean, it's only logical.  It's not just me, is it?  I swear, I'm going crazy trying to figure out why this isn't working.

I'm getting results like Resource id#3 and Resource id#4 instead of the fields that should be called when I used those commands.

Any ideas?

Source: http://community.livejournal.com/php/472517.html