MySQL select statement

[chancho]

Here is my code:

$login_query = "SELECT * FROM compinfo WHERE email = '$email' AND pswrd = PASSWORD('$pswrd')";
$login_result = mysql_query( $login_query, $link );

if ( !$login_result )
print 'Select failed.';

$aTemp = mysql_num_rows( $login_result );
print '<br /><br />rows: '.$aTemp;

The problem that I am having is that I am getting a $aTemp value of 0 - zero. Is there anything wrong with my SELECT statement? I am positive that I am submitting values that should be found in the email and pswrd columns, but I am not getting that result. I tested a SELECT statement with just a " WHERE email = '$email' " and omitted the pswrd part and it returned 1 row, as it should. The password that I am submitting via the $pswrd variable is the same password that is in MySQL. I can not see what the problem is. Your help is greatly appreciated.

[bav]

Try this

$login_query = "SELECT * FROM compinfo WHERE email = '$email' AND pswrd = PASSWORD('$pswrd')"; 
$login_result = mysql_query( $login_query, $link ); 

if(!$login_result) { print 'Select failed.'; }
$aTemp = mysql_num_rows( $login_result ); 

if($aTemp) { echo "lines: $aTemp"; }
else { echo "no line"; }

[chancho]

I just remembered that I had this problem before, I needed to set the length of any PASSWORD encrypted column to 16 characters, that is how many characters the encryption generates. Problem resolved.