Latest issue, crypt () causing problems.

[AStrangerWCandy]

Okay so adding crypt () to the password box on my Login script since I did on my registration script and am getting the following error after doing so:

 

Warning: mysql_result() expects parameter 1 to be resource, boolean given in URL on line 106

 

here is line 106:

 

$Count = mysql_result ($result2,0);

 

and here is the line in context to what I did:

 

$securepass = crypt ($_POST['password']);

$sql2 = "SELECT count(*) FROM Users WHERE userName='$_POST[username]' AND passWord='$securepass'";

$result2 = mysql_query($sql2);

$Count = mysql_result ($result2,0);

 

[ignace]

$securepass = crypt ($_POST['password']);

$sql2 = "SELECT count(*) FROM Users WHERE userName='$_POST[username]' AND passWord='$securepass'";

$result2 = mysql_query($sql2) or trigger_error('Error: ' . mysql_error());

$Count = mysql_result ($result2,0);